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  code block
  5. Add the line below to the  code block

     
  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.