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. |
| load_enabled | bit | Allow loading of transaction logs.
0 = Disable 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. |
| 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. |