Create New Database for each Case

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.