sp_delete_log_shipping_primary_database (Transact-SQL)

[ @database = ] 'database'

Is the name of the log shipping primary database. database is sysname, with no default, and cannot be NULL.

0 (success) or 1 (failure)

None.

sp_delete_log_shipping_primary_database must be run from the master database on the primary server. This stored procedure does the following:

1. Deletes the backup job for the specified primary database.
   
2. Removes the local monitor record in log_shipping_monitor_primary on the primary server.
   
3. Removes corresponding entries in log_shipping_monitor_history_detail and log_shipping_monitor_error_detail.
   
4. If the monitor server is different from the primary server, removes the monitor record in log_shipping_monitor_primary on the monitor server.
   
5. Removes corresponding entries in log_shipping_monitor_history_detail and log_shipping_monitor_error_detail on the monitor server.
   
6. Removes the entry in log_shipping_primary_databases for this primary database.
   
7. Calls sp_delete_log_shipping_alert_job on the monitor server.
   

Only members of the sysadmin fixed server role can run this procedure.

This example illustrates using sp_delete_log_shipping_primary_database to delete the primary database AdventureWorks.

EXEC master.dbo.sp_delete_log_shipping_primary_database @database = N'AdventureWorks';
GO

Reference

Other Resources

Help and Information