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_plan_databases System Table - SQL Server 2000

Print

RSS

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

This table is stored in the MSDB database.

Column name	Data type	Description
plan_id	uniqueidentifier	The plan ID for the maintenance plan that exists on the Secondary.
source_database	sysname	Primary database of a log shipping pair.
destination_database	sysname	Secondary database of a log shipping pair.
load_delay	int	Delay (in seconds) before restoring a transaction log after it is transferred to the secondary server.
load_all	bit	1 = Load all copied transaction logs.
last_file_copied	nvarchar(500)	File name of last transaction log copied.
date_last_copied	datetime	Date that last transaction log was copied.
last_file_loaded	nvarchar(500)	File name of last transaction log loaded.
date_last_loaded	datetime	Date that last transaction log was loaded.
copy_enabled	bit	Allow copying of transaction logs. 0=disable; 1 = enable.
load_enabled	bit	Allow loading of transaction logs. 0=disable; 1 = enable.
recover_db	bit	Roll back all uncompleted transactions after restore. 0=false; 1=true.
terminate_users	bit	1 = Terminate database users.

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