SQL Server 2000
This table is stored in the msdb database.
|Column name||Data type||Description|
|primary_id||int (IDENTITY)||Artificial unique key.|
|sysname||Name of primary server in log shipping pair.|
|sysname||Name of primary database in log shipping pair.|
|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.|
|bit||Status of threshold alert.
1 = Enabled.
|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.|
|int||Start time of the window during which threshold alerts will not be raised (in HHMMSS format).|
|int||End time of the window during which threshold alerts will not be raised (in HHMMSS format).|
|int||1 = Sunday |
2 = Monday
4 = Tuesday
8 = Wednesday
16 = Thursday
32 = Friday
64 = Saturday