You work as the database administrator at Domain.com. The Domain.com network consists of a single Active Directory domain named Domain.com. All servers on the Domain.com network run Windows Server2003 and all client computers run Windows XP Professional. The Domain.com network contains three SQL Server 2005 database servers named Certkiller -DB01, Certkiller -DB02, and Certkiller -DB03. Certkiller -DB01 hosts a database named CK_Sales that stores sales data for the company. Log shipping is configured on Certkiller -DB01 and Certkiller -DB02 with Certkiller -DB01 being the primary server. Domain.com users run queries and reports against the CK_Sales database on Certkiller -DB02. You want to store all status information for Certkiller -DB01 and Certkiller -DB02 on Certkiller -DB03.
What should you do?
A.
Configure Certkiller -DB03 as a monitor server.
B.
Configure Certkiller -DB03 as a witness server.
C.
Run the stored procedure sp_add_log_shipping_alert_job on Certkiller -DB01 and Certkiller -DB02.
D.
Run the stored procedure sp_add_log_shipping_alert_job on Certkiller -DB03.
Explanation:
To store status information for Certkiller -DB01 and Certkiller -DB02 on Certkiller -DB03 you must configure Certkiller -DB03 as a monitor server.
Incorrect Answers:
B: Witness servers are used with mirrored databases in high-safety mode to provide automatic failover. It is not used with log shipping.
C: The sp_add_log_shipping_alert_job stored procedure is used to configure a job for monitoring log shipping and must be run on the monitor server.
D: The sp_add_log_shipping_alert_job stored procedure is used to configure a job for monitoring log shipping and must be run on the monitor server. However, you must firs configure Certkiller -DB03 as a monitor server.
Reference:
Microsoft SQL Server 2005 Books Online (2006), Index: log shipping [SQL Server], about log shipping
Microsoft SQL Server 2005 Books Online (2006), Index: log shipping [SQL Server], stored procedures, sp_add_log_shipping_alert_job