How to restore customers and job tickets from audit trails



As an added safety measure and to help recover in the event of data corruption or loss, H2OS keeps separate databases, called "audit trails", for the customer and job tickets databases.


Each time a change (add, delete, change record content) is changed in either of these databases, duplicate records of these changes are added to the corresponding (customer list or job tickets) audit trail.


The data in these audit trails can be used to update a database that's been fully restored to an earlier date (for whatever reason).


At this time, it is assumed that the audit trail databases being used have not been damaged by the problem that causes corruption in the main databases that resulted in the full restore. That is, the scenario is:


(1) your H2OS customer and/or job tickets database have become corrupted

(2) you have restored both (the entire database) to an earlier point in time

(3) you now want to apply changes made to the customer and job tickets database since the date/time of the backup that was restored

(4) you have current and readable copies of the audit trails (either they weren't damaged or lost as were the main customer and/or job ticket databases or you have a more recent backup of the audit trails then the corrupted database you're restoring).



To restore a customer database from an audit trail, select the AUDIT page: (note: this page is not installed by default, you will need to work with H2OS Customer Support to install this page).





Setup the options on this page:


1. Select CUSTOMERS or JOB TICKETS as the database to be recovered

2. The DATABASE name (below the pulldown menu) will change to reflect your choice of database to be restored

3. Click the ellipsis command button to the right of AUDIT and use the navigator to locate the audit trail to be used in this operation (which you may have online or need to restore from a backup to prepare for this operation).

4. Commands are available to BROWSE and CLEAR this audit trail, but you probably wouldn't need to use them.

5. Select a date to recover from

6. Choose between being prompted to confirm each change or to perform the operation at once, without interaction

7. Click RECOVER



You will then be asked:





If you have selected the "Prompt to confirm .." option, you will be prompted for each change the recovery procedure discovers it needs to make





1. This procedure is different then restoring an H2OS backup