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

Software

PoweredBy

log_shipping_plan_databases System Table - SQL Server 2000

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 nameData typeDescription
plan_iduniqueidentifierThe plan ID for the maintenance plan that exists on the Secondary.
source_databasesysnamePrimary database of a log shipping pair.
destination_databasesysnameSecondary database of a log shipping pair.
load_delayintDelay (in seconds) before restoring a transaction log after it is transferred to the secondary server.
load_allbit1 = Load all copied transaction logs.
last_file_copiednvarchar(500)File name of last transaction log copied.
date_last_copieddatetimeDate that last transaction log was copied.
last_file_loadednvarchar(500)File name of last transaction log loaded.
date_last_loadeddatetimeDate that last transaction log was loaded.
copy_enabledbitAllow copying of transaction logs. 0=disable; 1 = enable.
load_enabledbitAllow loading of transaction logs. 0=disable; 1 = enable.
recover_dbbitRoll back all uncompleted transactions after restore. 0=false; 1=true.
terminate_usersbit1 = Terminate database users.

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