log_shipping_plans System Table - SQL Server 2000

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.