How to: Remove a Secondary Database (Transact-SQL)

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

  1. On the primary server, execute sp_delete_log_shipping_primary_secondary to delete the information about the secondary database from the primary server.

  2. On the secondary server, execute sp_delete_log_shipping_secondary_database to delete the secondary database.


    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


How to: Remove a Secondary Database (SQL Server Management Studio)


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)

Help and Information

Getting SQL Server 2005 Assistance