Auditing Database Recovery
If the auditing database has failed and EFT has been disconnected from the database for a while, you can prevent a loss of data by automatically saving auditing data to a text file when EFT is disconnected from the database. If EFT is configured to save auditing information to a text file, before reconnecting EFT to the database, repair the database, and then insert the data from the text file into the database. Then you can reconnect EFT to the database as described below.
The SQL statements logged in the text file must be loaded into the database before any reports are run.
If EFT is disconnected from the database and is configured to save auditing information to the log file, do the following:
-
Solve the connection problem.
-
Repair the database, and insert the data from the text file into the database. Be sure to insert the data only once, otherwise the auditing data will be corrupted.
-
In the administration interface, connect to EFT and click the Server tab.
-
On the Server tab, click the Server that you want to configure.
-
In the right pane, click the Logs tab and review the database connection information.
-
If you make any changes to the database host address, instance name, database name, etc., click Apply to apply these changes to EFT.)
-
Click Test Connection to test the status of the database connection.
-
The Connection status area indicates whether EFT is communicating with the database. To reconnect to the database, click Reconnect.