[ @primary_database = ] 'primary_database',
[ @secondary_server = ] 'secondary_server',
[ @secondary_database = ] 'secondary_database'
[ @primary_database = ] ' primary_database '
Is the name of the database on the primary server.
primary_database is , with no default. sysname [ @secondary_server = ] ' secondary_server '
Is the name of the secondary server.
secondary_server is , with no default. sysname [ @secondary_database = ] ' secondary_database '
Is the name of the secondary database.
secondary_database is , with no default. sysname
0 (success) or 1 (failure)
sp_delete_log_shipping_primary_secondary must be run from the master database on the primary server. This stored procedure removes the entry for a secondary database from log_shipping_primary_secondaries on the primary server.
Requires membership in the
sysadmin fixed server role.
In the following example,
sp_delete_log_shipping_primary_secondary is used to delete the secondary database LogShipAdventureWorks2008R2 from the secondary server FLATIRON.
@primary_database = N'AdventureWorks2008R2'
,@secondary_server = N'FLATIRON'
,@secondary_database = N'LogShipAdventureWorks2008R2'
Reference Concepts Other Resources