| 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; 1 = load. |
| succeeded | bit | Roll back all uncompleted transactions after restore: 0 = false; 1 = true. |
| 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. |