log_shipping_primaries
SQL Server 2000
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. |
