Return
-
Title
SQL Data Level Auditing does not record events for a database -
Description
After successfully configuring SQL Data Level Auditing (DLA) in Change Auditor, events are not recorded for a database.
A review of the SqlDla.Log.nptlog log file in the Change Auditor Agent directory records an error similar to the following:
2016-12-12 13:34:20.301 [14][ERROR][Dell.ChangeAuditor.SqlDla.LogReaderSession.CheckDatabaseRecoveryMode(0)] Unsupported database recovery mode (SIMPLE) used by database test_database. Database has to be in FULL recovery mode and has finished at least one backup to allow reliable auditing.
Sign In Required
You need to be signed in and under a current maintenance contract to view premium knowledge articles.