SQL Server 2000
This table is stored in the msdb database.
|Column name||Data type||Description|
|primary_id||int||Foreign key to log_shipping_primaries.|
|secondary_server_name||sysname||Name of secondary server in log shipping pair.|
|sysname||Name of secondary database in log shipping pair.|
|nvarchar(500)||File name of last transaction log copied to secondary server.|
|nvarchar(500)||File name of last transaction log loaded by secondary server.|
|datetime||Modification time of last transaction log file copied to secondary server.|
|datetime||Modification time of last transaction log file loaded by secondary server.|
|uniqueidentifier||Plan ID of the log shipping plan on the secondary server.|
|copy_enabled||bit||Allow copying of transaction logs.
0 = Disable copying.
|load_enabled||bit||Allow loading of transaction logs.
0 = Disable loading.
|int||Latency between last_loaded_filename and last_backup_file, after which the threshold alert will be raised.|
|threshold_alert||int||Error to be raised if the out_of_sync_threshold is exceeded.|
|bit||Status of threshold alert.
1 = Enabled.
|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
|bit||1 = Role change allowed.|