| 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; 1 = enable. |
| load_enabled | bit | Allow loading of transaction logs: 0 = disable; 1 = enable. |
| 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: 0 = disabled; 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. |