Audit Recovery Tool

Front End Access to Tool:

System Administration | Tools | Configuration | Framework | Restore Audit Data

 

Keep in mind before using the tool:

 

For SysAudit Table Restores:

 

Criteria Available to find Audit Data:

 

How to restore data for clients that do not have the Audit Restore Functionality yet:
  1. Utilize your local to access the front-end of the sysAudit Functionality. Add the filter criteria as you would enter it on the client site.
  2. Open SQL Profiler and get the EXEC created for sysRestoreAuditData script.
  3. Make sure you run all the below scripts on the client and that they run successfully:
    • B_00266_99999_fncSplit_NthItem.sql
    • C_02229_99999_sysSelectAuditTablesByTableName.sql
    • C_02237_99999_sysSelectAllTableColumns.sql
    • C_02238_99999_sysRestoreAuditData.sql
    • C_02258_99999_sysSelectAllForeignKeyReferencesByTableName.sql
    • C_02317_99999_sysSelectAllNonAuditTables.sql
  4. Utilize the EXEC (Step 2) to generate the selection of the records that will be restored. You can set the @Debug parameter to 1 if you'd like to get the select statement.
  5. Once you have confirmed that you are happy with the data displayed from the select, set @IsRestore equals to 1 and run the exec.
  6. Fix any issues if occurs (Mostly it will be FK Constraint issues from other tables that might not have the needed data anymore)
 
Videos

 


Revision #3
Created 6 April 2021 16:34:22
Updated 6 April 2021 17:10:54