Which of the following actions should you take?

You work as a database administrator at ABC.com.ABC.com is using a SQL Server 2008 R2
instance.
The SQL Server 2008 R2 instance contains a database, named ABC_Prod, which are log shipped
to a remote SQL Server 2008 R2 server. Subsequent to rebooting the primary SQL Server
instance, you notice that the log shipping is no longer functioning.
You have been tasked with finding the reason for the log shipping not functioning.
Which of the following actions should you take?

You work as a database administrator at ABC.com.ABC.com is using a SQL Server 2008 R2
instance.
The SQL Server 2008 R2 instance contains a database, named ABC_Prod, which are log shipped
to a remote SQL Server 2008 R2 server. Subsequent to rebooting the primary SQL Server
instance, you notice that the log shipping is no longer functioning.
You have been tasked with finding the reason for the log shipping not functioning.
Which of the following actions should you take?

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

B.
You should consider making use of the EXTENDED_LOGICAL_CHECKS option to run a
DBCC INDEXDEFRAG statement on ABC_Prod.

C.
You should make sure that the SQL Server Surface Area Configuration has been started on the
main server.

D.
You should make sure that the SQL Server Browser service has been started on the main
server.

Explanation:



Leave a Reply 0

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