试题详情
- 单项选择题You work in a company which is named Wiikigo Corp. The company uses SQL Server 2008. You are the administrator of the company database. Now you are in charge of a SQL Server 2008 instance. There is a database named Dworks in the instance. You are log shipping the Adventureworks database to a remote SQL Server 2008 instance. The primary SQL Server instance required a restart during the weekend. But you notice that log shipping has stopped working after the weekend. You have to check log shipping of the Adventureworks database and find out the problem. What should you do? （）
A、You should use the EXTENDED_LOGICAL_CHECKS option to execute a DBCC CHECKDB statement on the AdventureWorks database by.
B、You should identify whether the SQL Server Agent is started on the primary server.
C、You should identify whether the AdventureWorks database uses the Simple recovery model.
D、You should identify whether the SQL Server Volume Shadow Copy Service (VSS) Writer is started on the primary server
- B
关注下方微信公众号，在线模考后查看
热门试题