Follow

Create New Database for each Case

Created by: Justin Johns
Created date:
Last Updated date:

Problem

By default, FTK/Lab creates new cases in a single database using new schemas.  This can cause slowness in processing and other functions once this database becomes very large.

 

Resolution

FTK/Lab Version 6.0.1 and above:

1) Open FTK.

2) Select Database menu and select "Put each case in its own DB".

 

FTK/Lab Version 5.6.x:

The script below will cause FTK/Lab to create a new database for each case.  It should be used only on FTK/Lab version 5.6.

INSERT INTO ADG.ADG510.cmn_Settings (settingID, settingName, settingValue) values (0, 'CaseDatabaseSettings', '<CaseDatabaseSettings><MultiDB>true</MultiDB></CaseDatabaseSettings>')

 

Cause

The option to create a new database for each new case was added in version 6.0.1 of FTK/Lab. However, that setting is not the default (as of FTK/Lab version 6.2.1).

Summation Pro and AD eDiscovery already include this functionality.  

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

Comments

  • Avatar
    Kursad

    Great Tip thank you.

    I try to not create cases in LAB for consistency reasons but am sometimes forced to because of case requirements. This is a great way of keeping the ADG db small and lab cases in line with Summation cases.

Powered by Zendesk