Was this page helpful?
Your feedback about this content is important. Let us know what you think.
Additional feedback?
1500 characters remaining
Collapse the table of content
Expand the table of content


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.

© 2015 Microsoft