Question
How can I change the default SQL recovery mode for new projects' databases?
Prerequisites
Sammation or eDiscovery 5.6.3 SP 4 or newer
Answer
- Open services.msc
- Navigate to "C:\Program Files\AccessData\Common\FTK Business Services"
- Open "AdgWindowsServiceHost.exe.config" in a text editor
- Find the
<appSettings>
code block - Add the line below to the
<appSettings>
code block<add key="CaseDBRecoveryMode" value="2"/> <!-- Full (FullTransactionLogging) = 1, Simple (FullBackupRequired) = 2 -->
- Save the changes to "AdgWindowsServiceHost.exe.config"
- Restart the "AccessData Business Services Common" service
Overview
By default, new projects' databases are set to SIMPLE recovery mode. This can be changed by modifying a setting in AdgWindowsServiceHost.exe.config.
Comments