Export (0) Print
Expand All
Expand Minimize

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.
0 = Disabled.

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.

Was this page helpful?
(1500 characters remaining)
Thank you for your feedback
Show:
© 2014 Microsoft