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

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 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 3.0.1.400. Some of the icons created by FamFamFam. Except where noted, all contents Copyright © 1999-2024, Patrick Jasinski.