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

Print

RSS

Modified on Mon, Jun 08, 2009, 12:46 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	Log shipping plan ID.
plan_name	sysname	Log shipping plan name.
description	nvarchar(500)	User provided description of log shipping plan.
source_server	sysname	Primary server of log shipping pair.
source_dir	nvarchar(500)	Transaction log source directory on primary server.
destination_dir	nvarchar(500)	Transaction log destination directory on secondary server.
copy_job_id	uniqueidentifier	Copy job ID.
load_job_id	uniqueidentifier	Load job ID.
history_retention_period	int	Length of time to retain history rows for this plan.
file_retention_period	int	Length of time to retain copied transaction log files.
maintenance_plan_id	uniqueidentifier	Maintenance plan ID.
backup_job_id	uniqueidentifier	Backup job ID.
share_name	nvarchar(500)	Share name.

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