Note
Access to this page requires authorization. You can try signing in or changing directories.
Access to this page requires authorization. You can try changing directories.
This topic explains how to remove a secondary database from a log shipping configuration using Microsoft SQL Server Transact-SQL.
To Remove a Secondary Database
On the primary server, execute sp_delete_log_shipping_primary_secondary to delete the information about the secondary database from the primary server.
On the secondary server, execute sp_delete_log_shipping_secondary_database to delete the secondary database.
Note
If there are no other secondary databases with the same secondary ID, sp_delete_log_shipping_secondary_primary is invoked from sp_delete_log_shipping_secondary_database and deletes the entry for the secondary ID and the copy and restore jobs.
See Also
Tasks
How to: Remove a Secondary Database (SQL Server Management Studio)
Concepts
Log Shipping Tables and Stored Procedures
Other Resources
Log Shipping
sp_delete_log_shipping_primary_secondary (Transact-SQL)
sp_delete_log_shipping_secondary_database (Transact-SQL)
sp_delete_log_shipping_secondary_primary (Transact-SQL)