sys.sp_delete_log_shipping_primary_secondary

Description

Removes the entry for a secondary database on the primary server.

Syntax

sp_delete_log_shipping_primary_secondary
[ @primary_database = ]
N
'primary_database'
, [ @secondary_server = ]
N
'secondary_server'
, [ @secondary_database = ]
N
'secondary_database'
[ ; ]

Examples

Example 1

sp_delete_log_shipping_primary_secondary

Example 2

master

Example 3

log_shipping_primary_secondaries

Example 4

sp_delete_log_shipping_primary_secondary

Example 5

LogShipAdventureWorks

Example 6

FLATIRON

Example 7

EXECUTE master.dbo.sp_delete_log_shipping_primary_secondary
@primary_database = N
'AdventureWorks'
,
@secondary_server = N
'FLATIRON'
,
@secondary_database = N
'LogShipAdventureWorks'
;
GO