PrepAway - Latest Free Exam Questions & Answers

You need to troubleshoot log shipping of the Adventureworks database

You administer a SQL Server 2008 instance that contains a database named Ad venture
Works.
You are log shipping the Adventureworks database to a remote SQL Server 2008 instance.
During the weekend, the primary SQL Server instance required a restart. After the weekend,
you discover that log shipping has stopped working.
You need to troubleshoot log shipping of the Adventureworks database.
What should you do?

PrepAway - Latest Free Exam Questions & Answers

A.
Verify whether the SQL Server Agent is started on the primary server.

B.
Verify whether the AdventureWorks database uses the Simple recovery model.

C.
Verify whether the SQL Server Volume Shadow Copy Service (VSS) Writer is started on
the primary server.

D.
Execute a DBCC CHECKDB statement on the AdventureWorks database by using the
EXTENDED_LOGICAL_CHECKS option.


Leave a Reply