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

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.