Export (0) Print
Expand All
Expand Minimize

sp_remove_log_shipping_monitor

SQL Server 2000

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
Was this page helpful?
(1500 characters remaining)
Thank you for your feedback
Show:
© 2014 Microsoft