| primary_id | int (IDENTITY) | Artificial unique key. |
| primary_server_name | sysname | Name of primary server in log shipping pair. |
| primary_databasename | sysname | Name of primary database in log shipping pair. |
| maintenance_plan_id | uniqueidentifier | Maintenance plan ID. |
| backup_threshold | Int | Number of minutes without a backup occurring, before raising an error. |
| threshold_alert | int | Error to raise if transaction log backups stop occurring. |
| threshold_alert_enabled | bit | Status of threshold alert: 0 = disabled; 1 = enabled. |
| last_backup_filename | nvarchar(500) | File name of the most recent transaction log backup. |
| last_updated | datetime | Date (on the monitor server) that the primary last updated the last_backup_filename column. |
| planned_outage_start_time | int | Start time of the window during which threshold alerts will not be raised (in HHMMSS format). |
| planned_outage_end_time | int | End time of the window during which threshold alerts will not be raised (in HHMMSS format). |
| planned_outage_weekday_mask | int | 1 = Sunday; 2 = Monday; 4 = Tuesday; 8 = Wednesday; 16 = Thursday; 32 = Friday; 64 = Saturday |
| source_directory | nvarchar(500) | Source directory. |