What should you do next to troubleshoot the log shipping of CK_Prod?

You work as a database administrator at Domain.com. Domain.com is using a SQL Server
2008 instance. The SQL Server 2008 instance contains a database named CK_Prod which are
logged shipping to a remote SQL Server 2008. However, after reboot of the primary SQL Server
instance, you notice that the log shipping has no functionality. You need to troubleshoot the log
shipping of CK_Prod.

What should you do next?

You work as a database administrator at Domain.com. Domain.com is using a SQL Server
2008 instance. The SQL Server 2008 instance contains a database named CK_Prod which are
logged shipping to a remote SQL Server 2008. However, after reboot of the primary SQL Server
instance, you notice that the log shipping has no functionality. You need to troubleshoot the log
shipping of CK_Prod.

What should you do next?

A.
You should make sure that the SQL Server Agent is started on the main server.

B.
You should consider using the EXTENDED_LOGICAL_CHECKS option and run a DBCC
INDEXDEFRAG statement on CK_Prod.

C.
You should make sure that CK_Prod uses the Simple recovery model.

D.
You should consider using the EXTENDED_LOGICAL_CHECKS option and run a DBCC
CHECKDB statement on CK_Prod.



Leave a Reply 0

Your email address will not be published. Required fields are marked *