Was this page helpful?
Additional feedback?
1500 characters remaining
Export (0) Print
Expand All
Collapse the table of content
Expand the table of content
Expand Minimize


SQL Server 2000

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.
int Length of time to retain history rows for this plan.
int Length of time to retain copied transaction log files.
uniqueidentifier Maintenance plan ID.
backup_job_id uniqueidentifier Backup job ID.
share_name nvarchar(500) Share name.

Was this page helpful?
(1500 characters remaining)
Thank you for your feedback
© 2015 Microsoft