log_shipping_secondaries System Table - SQL Server 2000

This table is stored in the MSDB database.

Column nameData typeDescription
primary_idintForeign key to log_shipping_primaries.
secondary_server_namesysnameName of secondary server in log shipping pair.
secondary_database_namesysnameName of secondary database in log shipping pair.
last_copied_filenamenvarchar(500)File name of last transaction log copied to secondary server.
last_loaded_filenamenvarchar(500)File name of last transaction log loaded by secondary server.
last_copied_last_updateddatetimeModification time of last transaction log file copied to secondary server.
last_loaded_last_updateddatetimeModification time of last transaction log file loaded by secondary server.
secondary_plan_iduniqueidentifierPlan ID of the log shipping plan on the secondary server.
copy_enabledbitAllow copying of transaction logs: 0 = disable; 1 = enable.
load_enabledbitAllow loading of transaction logs: 0 = disable; 1 = enable.
out_of_sync_thresholdintLatency between last_loaded_filename and last_backup_file, after which the threshold alert will be raised.
threshold_alertintError to be raised if the out_of_sync_threshold is exceeded.
threshold_alert_enabledbitStatus of threshold alert: 0 = disabled; 1 = enabled.
planned_outage_start_timeintStart time of the window during which threshold alerts will not be raised (in HHMMSS format).
planned_outage_end_timeintEnd time of the window during which threshold alerts will not be raised (in HHMMSS format).
planned_outage_weekday_maskint1 = Sunday; 2 = Monday; 4 = Tuesday; 8 = Wednesday; 16 = Thursday; 32 = Friday; 64 = Saturday
allow_role_changebit1 = Role change allowed.