| Event Information | According to Microsoft
Cause:
sp_remove_log_shipping_monitor should be executed only after all rows from the log_shipping_databases and log_shipping_plans tables have been removed. Otherwise, this stored procedure will fail with the above error.
Resolution:
Before you can execute sp_remove_log_shipping_monitor you must first use sp_delete_log_shipping_plan to delete the log shipping plans and use sp_delete_log_shipping_database to delete all databases from the log_shipping_databases table on the primary server.
|
