Transact-SQL Reference
log_shipping_primaries
This table is stored in the msdb database.
| Column name | Data type | Description |
|---|---|---|
| primary_id | int (IDENTITY) | Artificial unique key. |
| primary_server_ name |
sysname | Name of primary server in log shipping pair. |
| primary_database name |
sysname | Name of primary database in log shipping pair. |
| maintenance_plan _id |
uniqueidentifier | Maintenance plan ID. |
| backup_threshold | Int | Number of minutes without a backup occurring, before raising an error. |
| threshold_alert | int | Error to raise if transaction log backups stop occurring. |
| threshold_alert_ enabled |
bit | Status of threshold alert.
1 = Enabled. |
| last_backup_ filename |
nvarchar(500) | File name of the most recent transaction log backup. |
| last_updated | datetime | Date (on the monitor server) that the primary last updated the last_backup_filename column. |
| 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 |
| source_directory | nvarchar(500) | Source directory. |