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.

  1. Click on 'View Log' in the left-hand toolbar. (Be sure to reset filter to all users if you have not done so earlier.)
  2. Refresh to get the most recent transactions (Click F5 or the Refresh button).
  3. Scroll to the end of the transaction log.
  4. Click on the last 'Modify' transaction. (This should be CustID 1000)
  5. 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:

  1. Select a row containing a prior value for address (e.g., '16 Champs Elysse').
  2. Right-click and select 'Rollback Row'.
  3. Select a location for the script file, and save the script.
  4. 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.