Jasinski Technical Wiki

Navigation

Home Page
Index
All Pages

Quick Search
»
Advanced Search »

Contributor Links

Create a new Page
Administration
File Management
Login/Logout
Your Profile

Other Wiki Sections

Software

PoweredBy

log_shipping_plan_history System Table - SQL Server 2000

RSS
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 3.0.1.400. Some of the icons created by FamFamFam. Except where noted, all contents Copyright © 1999-2018, Patrick Jasinski.