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, Certkiller -DB02, and Certkiller -DB03 with Certkiller -DB01 being the primary server and Certkiller -DB03 being a monitor server. Domain.com wants to stop using Certkiller -DB03 as a monitor server and wants you to reconfigure Certkiller -DB03 to host a database named CK_Projects.
What should you do?
A.
Remove log shipping on Certkiller -DB03.
B.
Remove log shipping on Certkiller -DB01.
C.
Run the stored procedure sp_delete_log_shipping_primary_database on Certkiller -DB01.
D.
Run the stored procedure
sp_delete_log_shipping_primary_secondary on Certkiller -DB03.
Explanation:
When a monitor server is added to a log shipping configuration, the monitor server cannot be changed. If you want to change the monitor server, you must first remove log shipping. This task must be performed on the primary server.
Incorrect Answers:
A: You must remove log shipping on the primary server, not on the monitor server.
C: The sp_delete_log_shipping_primary_database stored procedure is used to remove log shipping of the primary database including backup job as well as local and remote history. However, this stored procedure must be run after you have run the sp_delete_log_shipping_primary_secondary stored procedure to remove the secondary databases.
D: The sp_delete_log_shipping_primary_secondary stored procedure removes the secondary databases but it must be run on the primary server, not the 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], removing
Microsoft SQL Server 2005 Books Online (2006), Index: log shipping [SQL Server], stored procedures, sp_delete_log_shipping_primary_database Microsoft SQL Server 2005 Books Online (2006), Index: log shipping [SQL Server], stored procedures, sp_delete_log_shipping_primary_secondary