log_shipping_primary_secondaries (Transact-SQL)log_shipping_primary_secondaries (Transact-SQL)

适用于: 是SQL Server 否Azure SQL 数据库 否Azure Synapse Analytics (SQL DW) 否并行数据仓库 APPLIES TO: YesSQL Server NoAzure SQL Database NoAzure Synapse Analytics (SQL DW) NoParallel Data Warehouse

将每个主数据库映射到其辅助数据库。Maps each primary database to its secondary databases. 该表存储在msdb数据库中。This table is stored in the msdb database.

列名称Column name 数据类型Data type 说明Description
primary_idprimary_id uniqueidentifieruniqueidentifier 日志传送配置的主数据库 ID。The ID of the primary database for the log shipping configuration.
secondary_serversecondary_server sysnamesysname 日志传送配置中的MicrosoftMicrosoft SQL Server 数据库引擎SQL Server Database Engine辅助实例的名称。The name of the secondary instance of the MicrosoftMicrosoft SQL Server 数据库引擎SQL Server Database Engine in the log shipping configuration.
secondary_databasesecondary_database sysnamesysname 日志传送配置中辅助数据库的名称。The name of the secondary database in the log shipping configuration.

另请参阅See Also

关于日志传送 (SQL Server) About Log Shipping (SQL Server)
sp_add_log_shipping_primary_secondary (Transact-sql) sp_add_log_shipping_primary_secondary (Transact-SQL)
sp_delete_log_shipping_primary_secondary (Transact-sql) sp_delete_log_shipping_primary_secondary (Transact-SQL)
sp_help_log_shipping_primary_secondary (Transact-sql) sp_help_log_shipping_primary_secondary (Transact-SQL)
系统表 (Transact-SQL)System Tables (Transact-SQL)