| 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; 1 = enable. |
| load_enabled | bit | Allow loading of transaction logs. 0=disable; 1 = enable. |
| recover_db | bit | Roll back all uncompleted transactions after restore. 0=false; 1=true. |
| terminate_users | bit | 1 = Terminate database users. |