Stores one monitor record per secondary database in a log shipping configuration. 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|
|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.|
|secondary_id||uniqueidentifier||The ID for the secondary server in the log shipping configuration.|
|primary_server||sysname||The name of the primary instance of the SQL Server Database Engine in the log shipping configuration.|
|primary_database||sysname||The name of the primary database in the log shipping configuration.|
|restore_threshold||int||The number of minutes allowed to elapse between restore operations before an alert is generated.|
|threshold_alert||int||The alert to be raised when the restore threshold is exceeded.|
|threshold_alert_enabled||bit||Determines if restore threshold alerts are enabled. 1 = Enabled.|
0 = Disabled.
|last_copied_file||nvarchar(500)||The filename of the last backup file copied to the secondary server.|
|last_copied_date||datetime||The time and date of the last copy operation to the secondary server.|
|last_copied_date_utc||datetime||The time and date of the last copy operation to the secondary server, expressed in Coordinated Universal Time.|
|last_restored_file||nvarchar(500)||The filename of the last backup file restored to the secondary database.|
|last_restored_date||datetime||The time and date of the last restore operation on the secondary database.|
|last_restored_date_utc||datetime||The time and date of the last restore operation on the secondary database, expressed in Coordinated Universal Time.|
|last_restored_latency||int||The amount of time, in minutes, that elapsed between when the log backup was created on the primary and when it was restored on the secondary.|
The initial value is NULL.
|history_retention_period||int||The amount of time, in minutes, that log shipping history records are retained for a given secondary database before being deleted.|
In addition to being stored on the remote monitor server, and information related to a secondary server is also stored on the secondary server in its log_shipping_monitor_secondary table.
About Log Shipping (SQL Server)
System Tables (Transact-SQL)