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.
'
Comments (
)
)
Link to this page:
//www.vb-net.com/Sql/Sql/Ts_sp_da-di_77s9.htm
|
|