log_shipping_monitor_primary (Transact-SQL)log_shipping_monitor_primary (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

在每个日志传送配置中为每个主数据库存储一条监视记录。Stores one monitor record per primary database in each log shipping configuration. 该表存储在msdb数据库中。This table is stored in the msdb database.

与历史记录和监视相关的表也用于主服务器和辅助服务器。The tables related to history and monitoring are also used at the primary server and the secondary servers.

列名称Column name 数据类型Data type 说明Description
primary_idprimary_id uniqueidentifieruniqueidentifier 日志传送配置的主数据库 ID。The ID of the primary database for the log shipping configuration.
primary_serverprimary_server sysnamesysname 日志传送配置中 MicrosoftMicrosoft SQL Server 数据库引擎SQL Server Database Engine主实例的名称。The name of the primary instance of the MicrosoftMicrosoft SQL Server 数据库引擎SQL Server Database Engine in the log shipping configuration.
primary_databaseprimary_database sysnamesysname 日志传送配置中主数据库的名称。The name of the primary database in the log shipping configuration.
backup_thresholdbackup_threshold intint 备份操作之间的占用时间阈值(分钟),一旦超过此值,就会生成警报。The number of minutes allowed to elapse between backup operations before an alert is generated.
threshold_alertthreshold_alert intint 超过备份阈值时引发的警报。The alert to be raised when the backup threshold is exceeded.
threshold_alert_enabledthreshold_alert_enabled bitbit 确定是否启用备份阈值警报。Determines if backup threshold alerts are enabled. 1 = 启用。1 = Enabled.

0 = 禁用。0 = Disabled.
last_backup_filelast_backup_file nvarchar (500)nvarchar(500) 最近一次事务日志备份的绝对路径。The absolute path of the most recent transaction log backup.
last_backup_datelast_backup_date datetimedatetime 上一次在主数据库上执行事务日志备份操作的时间和日期。The time and date of the last transaction log backup operation on the primary database.
last_backup_date_utclast_backup_date_utc datetimedatetime 上一次在主数据库上执行事务日志备份操作的时间和日期,使用协调世界时表示。The time and date of the last transaction log backup operation on the primary database, expressed in Coordinated Universal Time.
history_retention_periodhistory_retention_period intint 日志传送历史记录在删除前保留在给定主数据库中的时间(分钟)。The amount of time, in minutes, that log shipping history records are retained for a given primary database before being deleted.


除了存储在远程监视服务器上外,与主服务器有关的信息存储在主服务器上的log_shipping_monitor_primary表中。In addition to being stored on the remote monitor server, the information related to the primary server is stored on the primary server in its log_shipping_monitor_primary table.

另请参阅See Also

关于日志传送 (SQL Server) About Log Shipping (SQL Server)
sp_add_log_shipping_primary_database (Transact-sql) sp_add_log_shipping_primary_database (Transact-SQL)
sp_change_log_shipping_primary_database (Transact-sql) sp_change_log_shipping_primary_database (Transact-SQL)
sp_delete_log_shipping_primary_database (Transact-sql) sp_delete_log_shipping_primary_database (Transact-SQL)
sp_help_log_shipping_primary_database (Transact-sql) sp_help_log_shipping_primary_database (Transact-SQL)
sp_refresh_log_shipping_monitor (Transact-sql) sp_refresh_log_shipping_monitor (Transact-SQL)
sp_help_log_shipping_monitor_primary (Transact-sql) sp_help_log_shipping_monitor_primary (Transact-SQL)
sp_delete_log_shipping_alert_job (Transact-sql) sp_delete_log_shipping_alert_job (Transact-SQL)
系统表 (Transact-SQL)System Tables (Transact-SQL)