How to remove a log shipping pair from the Log Shipping Monitor (Transact-SQL)

How to Install SQL Server 2000

How To

How to remove a log shipping pair from the Log Shipping Monitor (Transact-SQL)

To remove a log shipping pair from a Log Shipping Monitor on an instance of Microsoft® SQL Server 2000

  • Run sp_delete_log_shipping_monitor_info on the monitor server. This informs the monitor server which log shipping pair will be deleted. Note that the actual log shipping pair is not deleted. Only the monitor will be affected by this operation.

  • Optionally, run sp_delete_database_backuphistory on the primary and secondary servers. This removes backup history information about members of the deleted log shipping pair.
Examples

This example removes a log shipping pair from a Log Shipping Monitor for an existing log shipping pair of the Northwind database:

EXEC sp_delete_log_shipping_monitor_info
   @primary_server_name = 'MyPrimaryServer',
   @primary_database_name = 'Northwind',
   @secondary_server_name = 'MySecondaryServer',
   @secondary_database_name = 'Northwind'
GO

Optionally, the following stored procedure call can be used to remove backup history information about the deleted members of a log shipping pair. Execute this command on each of the primary and secondary servers:

EXEC sp_delete_database_backuphistory 'Northwind'
GO

sp_delete_log_shipping_monitor_info

''''''''