Transact-SQL Reference
log_shipping_plans
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. |