YouworkinacompanywhichisnamedWiikigoCorp.ThecompanyusesSQLServer2008.Youaretheadministratorofthecompanydatabase.NowyouareinchargeofaSQLServer2008instance.ThereisadatabasenamedDworksintheinstance.YouarelogshippingtheAdventureworksdatabasetoaremoteSQLServer2008instance.TheprimarySQLServerinstancerequiredarestartduringtheweekend.Butyounoticethatlogshippinghasstoppedworkingaftertheweekend.YouhavetochecklogshippingoftheAdventureworksdatabaseandfindouttheproblem.Whatshouldyoudo?（）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

单项选择题

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

MCTS(70-432)