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. 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.