log_shipping_primary_secondaries (Transact-SQL)


Updated: June 10, 2016

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 nameData typeDescription
primary_iduniqueidentifierThe ID of the primary database for the log shipping configuration.
secondary_serversysnameThe name of the secondary instance of the Microsoft SQL Server Database Engine in the log shipping configuration.
secondary_databasesysnameThe name of the secondary database in the log shipping configuration.

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)

Community Additions