SQL Server 2000
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.|
|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.|