sp_remove_log_shipping_monitor

Transact-SQL Reference

Transact-SQL Reference

sp_remove_log_shipping_monitor

Deletes the log shipping monitor information from the log_shipping_monitor table.

Syntax

sp_remove_log_shipping_monitor

Return Code Values

0 (success) or 1 (failure)

Remarks

This stored procedure removes the monitor from either the primary or secondary server. sp_remove_log_shipping_monitor should be executed after all rows from the log_shipping_databases and log_shipping_plans have been removed. Otherwise, this stored procedure will fail.

Permissions

Only members of the sysadmin fixed server role can execute sp_remove_log_shipping_monitor.

Examples
EXEC   msdb.dbo.sp_remove_log_shipping_monitor