sp_delete_log_shipping_secondary

Transact-SQL Reference

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.