Jasinski Technical Wiki


Home Page
All Pages

Quick Search
Advanced Search »

Contributor Links

Create a new Page
File Management
Your Profile

Other Wiki Sections



log_shipping_plan_history System Table - SQL Server 2000

Modified on Mon, Jun 08, 2009, 12:45 PM by Administrator Categorized as SQL Server System Tables
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.

ScrewTurn Wiki version Some of the icons created by FamFamFam. Except where noted, all contents Copyright © 1999-2023, Patrick Jasinski.