log_shipping_primary_secondaries (Transact-SQL)

THIS TOPIC APPLIES TO:yesSQL Server (starting with 2008)noAzure SQL DatabasenoAzure SQL Data Warehouse noParallel Data Warehouse

Maps each primary database to its secondary databases. This table is stored in the msdb database.

Column name Data type Description
primary_id uniqueidentifier The ID of the primary database for the log shipping configuration.
secondary_server sysname The name of the secondary instance of the Microsoft SQL Server Database Engine in the log shipping configuration.
secondary_database sysname The name of the secondary database in the log shipping configuration.

See Also

About Log Shipping (SQL Server)
sp_add_log_shipping_primary_secondary (Transact-SQL)
sp_delete_log_shipping_primary_secondary (Transact-SQL)
sp_help_log_shipping_primary_secondary (Transact-SQL)
System Tables (Transact-SQL)