|
|
|
|
|
Log Explorer 1.2.1 1 2 3 4 5 6 7 8 9 10 The Row Transaction History displays a summary recap of the transactions issued against a particular row of data. It does not display all of the row information or give you the ability to reconstruct a row. It does give you an idea of the activity performed against a row. From there, you can jump back to a Browse which will give you the ability to reverse the selected transaction. The difference between Row Revision History and Row Transaction History is that the revision history will reconstruct the contents of the row of data before a transaction was made whereas transaction history will not.
The capability outlined here does not currently exist in any other product. With SQL: Server 6.5, Platinum's (now Computer Associates) Log Analyzer provided this same capability. There were several cases where I used it to troubleshoot problems. The first use came when trying to determine what a 3rd party application had done to destroy data in one of my production databases. It quickly isolated the transaction, provided proof, and also gave me the ability to repair the damage. The other times that I used that product was in the recovery of damaged data due to user error. It provided an ability to recover without having to take a mission critical, high volume database offline and restore it. While I haven't had a case where I used Log Explorer, there were many cases over the last year and a half that I would have given anything to have it. There are few products out there that I would say are absolute, must-haves. Log Explorer is only the second product that I would say is a must for any company running SQL Server 7.0. You won't use it every day, but when you need it, Log Explorer will save you plenty of time, effort, and money. Log Explorer is produced by Lumigent Technologies and currently retails for $995 per server. At the time of writing version 1.3 was just released and SQL Server 2000 support was in beta testing. If you think that is a lot, how much is your data worth? |
All content on this site, except where noted, represents an original work of Michael R. Hotek and is protected by applicable copyright laws. The SQL Server FAQ is the sole work of Neil Pike. No page, portion of a page, or download may be used for commercial purposes in whole or in part without the express, written permission of the applicable author.
