Was this page helpful?
Your feedback about this content is important. Let us know what you think.
Additional feedback?
1500 characters remaining
Export (0) Print
Expand All
Collapse the table of content
Expand the table of content
Expand Minimize


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.
1 = Load.

succeeded bit Roll back all uncompleted transactions after restore.

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
© 2015 Microsoft