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.

Was this page helpful?
(1500 characters remaining)
Thank you for your feedback
Show:
© 2014 Microsoft