sys.sp_help_log_shipping_secondary_database

Description

This stored procedure retrieves the settings for one or more secondary databases.

Syntax

sp_help_log_shipping_secondary_database
[ [ @secondary_database = ]
N
'secondary_database'
]
[ , [ @secondary_id = ]
'secondary_id'
]
[ ; ]

Permissions

If you include the @secondary_database parameter, the result set contains information about that secondary database; if you include the @secondary_id parameter, the result set contains information about all secondary databases associated with that secondary ID. must be run from the database on the secondary server. Only members of the fixed server role can run this procedure. sp_help_log_shipping_secondary_primary (Transact-SQL) About log shipping (SQL Server) System stored procedures (Transact-SQL)