Export (0) Print
Expand All
Expand Minimize

log_shipping_plan_history

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

Show:
© 2014 Microsoft