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.
© 2024 Quest Software Inc. ALL RIGHTS RESERVED. Feedback Terms of Use Privacy Cookie Preference Center