log_shipping_plan_history System Table - SQL Server 2000

This table is stored in the MSDB database.

Column nameData typeDescription
sequence_idintThe sequence in which rows were inserted.
plan_iduniqueidentifierLog shipping plan ID.
source_databasesysnameName of primary database in log shipping pair.
destination_databasesysnameName of secondary database in log shipping pair.
activitybitThe action performed: 0 = copy; 1 = load.
succeededbitRoll back all uncompleted transactions after restore: 0 = false; 1 = true.
num_filesintNumber of transaction logs shipped to secondary server.
last_filenvarchar(256)Name of the last file on which this action was performed.
end_timedatetimeTime and date when which action completed.
durationintAmount of time (in seconds) taken to complete the action.
error_numberintLast error number encountered by the action.
messagenvarchar(500)Last error message encountered by the action.