Transact-SQL Reference

sp_delete_log_shipping_monitor_info

Removes a log shipping pair from a log shipping monitor.

Syntax

sp_delete_log_shipping_monitor_info
    [ @primary_server_name = ] 'primary_server_name' ,
    [ @primary_database_name = ] 'primary_database_name' ,
    [ @secondary_server_name = ] 'secondary_server_name' ,
    [ @secondary_database_name = ] 'secondary_database_name' }

Arguments

[@primary_server_name =] 'primary_server_name'

Is the name of the primary server. primary_server_name is sysname.

[@primary_database_name =] 'primary_database_name'

Is the name of the primary database. primary_database_name is sysname.

[@secondary_server_name =] 'secondary_server_name'

Is the name of the secondary server. primary_server_name is sysname.

[@secondary_database_name =] 'secondary_database_name'

Is the name of the secondary database. primary_database_name is sysname.

Return Code Values

0 (success) or 1 (failure)

Remarks

Run sp_delete_log_shipping_monitor_info to notify the monitor server which log shipping pair will be deleted from the monitor. This stored procedure must be executed on the instance of Microsoft® SQL Server™ 2000 that is acting as the monitor.

Note that the actual log shipping pair is not deleted. Only the monitor is affected by this operation.

Permissions

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