Export (0) Print
Expand All
Expand Minimize

log_shipping_plans

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

Show:
© 2014 Microsoft