Transact-SQL Reference
log_shipping_plan_history
This table is stored in the msdb database.
| Column name | Data type | Description |
|---|---|---|
| sequence_id | int | The sequence in which rows were inserted. |
| plan_id | uniqueidentifier | Log shipping plan ID. |
| source_database | sysname | Name of primary database in log shipping pair. |
| destination_ database |
sysname | Name of secondary database in log shipping pair. |
| activity | bit | The action performed.
0 = Copy. |
| succeeded | bit | Roll back all uncompleted transactions after restore.
0 = FALSE |
| num_files | int | Number of transaction logs shipped to secondary server. |
| last_file | nvarchar(256) | Name of the last file on which this action was performed. |
| end_time | datetime | Time and date when which action completed. |
| duration | int | Amount of time (in seconds) taken to complete the action. |
| error_number | int | Last error number encountered by the action. |
| message | nvarchar(500) | Last error message encountered by the action. |