Change Default SQL Recovery Mode for New Projects

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

1. Open services.msc
2. Navigate to "C:\Program Files\AccessData\Common\FTK Business Services"
3. Open "AdgWindowsServiceHost.exe.config" in a text editor
4. Find the <appSettings> code block
5. Add the line below to the <appSettings> code block
   
   <add key="CaseDBRecoveryMode" value="2"/>  <!-- Full (FullTransactionLogging) = 1,  Simple (FullBackupRequired) = 2 -->


6. Save the changes to "AdgWindowsServiceHost.exe.config"
7. 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.