log_shipping_secondaries

Transact-SQL Reference

Transact-SQL Reference

log_shipping_secondaries

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.
secondary_
database_name
sysname Name of secondary database in log shipping pair.
last_copied_
filename
nvarchar(500) File name of last transaction log copied to secondary server.
last_loaded_
filename
nvarchar(500) File name of last transaction log loaded by secondary server.
last_copied_last_
updated
datetime Modification time of last transaction log file copied to secondary server.
last_loaded_last_
updated
datetime Modification time of last transaction log file loaded by secondary server.
secondary_plan_
id
uniqueidentifier Plan ID of the log shipping plan on the secondary server.
copy_enabled bit Allow copying of transaction logs.

0 = Disable copying.
1 = Enable copying.

load_enabled bit Allow loading of transaction logs.

0 = Disable loading.
1 = Enable loading.

out_of_sync_
threshold
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.
threshold_alert_
enabled
bit Status of threshold alert.

1 = Enabled.
0 = Disabled.

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
allow_role_
change
bit 1 = Role change allowed.