Jasinski Technical Wiki


Home Page
All Pages

Quick Search
Advanced Search »

Contributor Links

Create a new Page
File Management
Your Profile

Other Wiki Sections



log_shipping_plans System Table - SQL Server 2000

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 nameData typeDescription
plan_iduniqueidentifierLog shipping plan ID.
plan_namesysnameLog shipping plan name.
descriptionnvarchar(500)User provided description of log shipping plan.
source_serversysnamePrimary server of log shipping pair.
source_dirnvarchar(500)Transaction log source directory on primary server.
destination_dirnvarchar(500)Transaction log destination directory on secondary server.
copy_job_iduniqueidentifierCopy job ID.
load_job_iduniqueidentifierLoad job ID.
history_retention_periodintLength of time to retain history rows for this plan.
file_retention_periodintLength of time to retain copied transaction log files.
maintenance_plan_iduniqueidentifierMaintenance plan ID.
backup_job_iduniqueidentifierBackup job ID.
share_namenvarchar(500)Share name.

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