sys.sp_change_log_shipping_secondary_primary

Description

Changes secondary database settings.

Syntax

sp_change_log_shipping_secondary_primary
[ @primary_server = ]
'primary_server'
,
[ @primary_database = ]
'primary_database'
,
[ , [ @backup_source_directory = ]
N
'backup_source_directory'
]
[ , [ @backup_destination_directory = ]
N
'backup_destination_directory'
]
[ , [ @file_retention_period = ] file_retention_period ]
[ , [ @monitor_server_security_mode = ] monitor_server_security_mode ]
[ , [ @monitor_server_login = ]
'monitor_server_login'
]
[ , [ @monitor_server_password = ]
'monitor_server_password'
]
[ , [ @monitor_connection_options = ]
'<key_value_pairs>;[.]'
]
[ ; ]