29 December,17 at 11:19 PM
Question:
Both Centrify Audit and Management databases are created with simple recovery mode by default. Will there be any negative effects if they are changed to full recovery mode?
Answer:
Simple recovery mode doesn't allow a point in time recovery of data so in the case of a database problem, you can lose up to a full day's worth of data. Full recovery mode protects against this.
In the past, DirectAudit databases installed with full recovery mode by default for this reason but it was changed a few versions ago due to the growth of the LDF file . With full recovery mode, you'll need to monitor the size of the LDF file. Depending on how much data your environment collects, the transaction logs (LDF file) may consume a lot of disk space. A good practice is to monitor the LDF file periodically to assess the impact of full recovery mode on disk usage.