sys.sp_add_log_shipping_primary_secondary

Description

This stored procedure adds an entry for a secondary database on the primary server.

Syntax

sp_add_log_shipping_primary_secondary
[ @primary_database = ]
'primary_database'
,
[ @secondary_server = ]
'secondary_server'
,
[ @secondary_database = ]
'secondary_database'
[ ; ]

Examples

Example 1

sp_add_log_shipping_primary_secondary

Example 2

master

Example 3

sp_add_log_shipping_primary_secondary

Example 4

LogShipAdventureWorks

Example 5

FLATIRON

Example 6

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