Transact-SQL Reference
sp_delete_log_shipping_secondary
Removes a secondary server from log_shipping_secondaries table.
Syntax
sp_delete_log_shipping_secondary
[ @secondary_server_name = ] 'secondary_server_name' ,
[ @secondary_database_name = ] 'secondary_database_name'
Arguments
[@secondary_server_name =] 'secondary_server_name'
Is the secondary server name. secondary_server_name is sysname.
[@secondary_database_name =] 'secondary_database_name'
Is the secondary database name. secondary_database_name is sysname.
Return Code Values
0 (success) or 1 (failure)
Remarks
This stored procedure removes matching databases from log_shipping_secondaries table.
Permissions
Only members of the sysadmin fixed server role can execute the sp_delete_log_shipping_secondary.