|
|
|
|
|
The Recover menu as seen below is the
heart of the Log Analyzer and what makes this tool worth its weight in gold. This
will bring up a dialog box that allows you to specify the page and row number for the
transaction you are interested in.
The recover menu will lead you to the same dialog as the File | Save menu and this is where the power of the Log Analyzer is displayed. You'll notice row 27 in the syslogs view, is an insert that I did on the authors table. This is contained on page 788, row 26 of my transaction log. I need to fill this in as shown below.
Now, from here I can do three things. I can create a file that contains an undo statement. Since this was an insert, it will generate a delete statement as shown below.
If I wanted to generate a file that redoes this transaction, I will get my original insert statement back as shown below.
The report option just generates a report as shown below.
|
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.
