Transact-SQL Reference
log_shipping_plan_databases
This table is stored in the msdb database.
| Column name | Data type | Description |
|---|---|---|
| plan_id | uniqueidentifier | The plan ID for the maintenance plan that exists on the Secondary. |
| source_database | sysname | Primary database of a log shipping pair. |
| destination_database | sysname | Secondary database of a log shipping pair. |
| load_delay | int | Delay (in seconds) before restoring a transaction log after it is transferred to the secondary server. |
| load_all | bit | 1 = Load all copied transaction logs. |
| last_file_copied | nvarchar(500) | File name of last transaction log copied. |
| date_last_copied | datetime | Date that last transaction log was copied. |
| last_file_loaded | nvarchar(500) | File name of last transaction log loaded. |
| date_last_loaded | datetime | Date that last transaction log was loaded. |
| copy_enabled | bit | Allow copying of transaction logs.
0 = Disable copying. |
| load_enabled | bit | Allow loading of transaction logs.
0 = Disable loading. |
| recover_db | bit | Roll back all uncompleted transactions after restore.
0 = FALSE |
| terminate_users | bit | 1 = Terminate database users. |