|
|
|
|
|
Log Explorer 1.2.1 1 2 3 4 5 6 7 8 9 10 The next two items can get a little confusing and I'm still not sure why they were separated. Selecting Rollback will display the screen below. The Rollback is used for any modification to a row. It will generate an insert/update/delete statement that will return the row of data back to its previous state. Ever had a user that changed the value of a piece of data, realized they had made a mistake after committing it, and then couldn't remember what was there before? You can now make them worry and sweat about the repercussions, just to make sure they don't do it again, and then "magically" reset the data to what it was prior to their change. You can specify an individual table or all tables along with an optional SPID. I'm not sure why username, which you will usually know, is not included on this screen instead of SPID, which you will rarely know. You can also select a date/time for recovery. The label on the screen is a mistake. The date/time you select is NOT the date/time you will get a recovery script to. Instead it is the date/time that Log Explorer STARTS from and then generates everything to the end of the log. We should see this capability fixed and enhanced in the near future.
Selecting Undelete will apply to any rows that have been deleted from a table. As I said above, I'm not sure why this has been separated from a Rollback since both perform the same basic operations and that is to provide a SQL script to reverse the change that had been done. The same information that you can specify for a Rollback applies here as well.
|
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.
