This topic has not yet been rated - Rate this topic

How to: Remove Log Shipping (Transact-SQL)

SQL Server 2008 R2

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

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.

Did you find this helpful? Yes No

Not accurate

Not enough depth

Need more code examples

(1500 characters remaining)

Community Additions