Auditing Database Recovery

The SQL statements logged in the text file must be loaded into the database before any reports are run.

If EFT Server is disconnected from the SQL database and is configured to save auditing information to the log file, do the following:

  1. Solve the connection problem.

  2. Repair the database, and insert the data from the text file into the SQL database. Be sure to insert the data only once, otherwise the auditing data will be corrupted.

  3. In EFT Administrator, connect to EFT Server and click the Server tab.

  4. In the left pane, click the Server you want to configure.

  5. In the right pane, click the Auditing tab.

  6. Under Database Audit Settings, click Test Connection to test the status of the database connection. (You must click Apply to apply any changes first.)

  7. To reconnect to the database, click Reconnect.