Jasinski Technical Wiki

Navigation

	Home Page
	Index
	All Pages

Quick Search

Advanced Search »

Contributor Links

	Create a new Page
	Administration
	File Management
	Login/Logout
	Your Profile

Other Wiki Sections

PoweredBy

Discuss (0) History

log_shipping_secondaries System Table - SQL Server 2000

Print

RSS

Modified on Mon, Jun 08, 2009, 12:47 PM by Administrator Categorized as SQL Server System Tables

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; 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.

ScrewTurn Wiki version 3.0.1.400. Some of the icons created by FamFamFam. Except where noted, all contents Copyright © 1999-2024, Patrick Jasinski.