Follow

Change Default SQL Recovery Mode for New Projects

Created by: Brendan Bone
Created date:
Last Updated date:

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.

Was this article helpful?
0 out of 0 found this helpful
Have more questions? Submit a request

Comments

Powered by Zendesk