How to: Remove Log Shipping (Transact-SQL)

This topic explains how to remove log shipping using Microsoft SQL Server Transact-SQL.

To Remove Log Shipping

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.
On the primary server, execute sp_delete_log_shipping_primary_database to delete information about the log shipping configuration from the primary server. This also deletes the backup job.
Delete the secondary database from the secondary server if desired.