View Changes and Restore Row
As usual, there are several ways to find the record of interest. Because we
know that the record of interest was just modified, we can browse to the end
of the transaction log and easily select a transaction for the customer in question.
- Click on 'View Log' in the left-hand toolbar. (Be sure to reset filter to
all users if you have not done so earlier.)
- Refresh to get the most recent transactions (Click F5 or the Refresh button).

- Scroll to the end of the transaction log.
- Click on the last 'Modify' transaction. (This should be CustID 1000)
- Right-click on the transaction, and select 'Revision History'.
The Row Revision History screen reconstructs the row as it appeared after each
transaction that affected that row. The top line shows the current value of
the row. To roll back to a previous set of values:
- Select a row containing a prior value for address (e.g., '16 Champs Elysse').
- Right-click and select 'Rollback Row'.
- Select a location for the script file, and save the script.
- Review the resulting SQL script in the NOTEPAD window.
Note that Log Explorer never modifies your data directly. You can (and
should!) always review the resulting script before applying the changes.
Click 'Next' to continue.