Database and Maintenance

PostgreSQL 11 to 14 Migration Guides
The following migration guides cover all steps required for users to migrate their cases to PostgreSQL 14.0;  FTK 7.5.2 to 7.6 SP3  FTK 7.6+
Wed, Aug 2, 2023 at 4:30 AM
Validate Database: Failure ADG7x1 Expected Sequence But Not Found in Existing Schema
Problem When performing a Validate in DBConfig.exe Tool, you get various errors with 'Failure ADG7x1 Expected Sequence but not found in existing schema...
Thu, May 25, 2023 at 3:37 PM
Cannot Open Database ADG Requested by the Login. The login failed.
Problem When performing a database Validate or Update, the service account does not have permission to the SQL databases.   Resolution The service ...
Fri, Jun 23, 2023 at 1:43 PM
Delete a case using DBControl
Problem An attempt to delete a case failed using one of the Forensic Tools interfaces. The case no longer shows in the case list, but you still see it i...
Fri, Jun 23, 2023 at 1:42 PM
PostgreSQL 14: Migration Failure & Steps to revert to an older version.
Scenario 1: Permission issues   Description:   While the Database migration is in progress, If the Read/Write permissions to the case directories are...
Fri, Jun 23, 2023 at 1:42 PM
FTK 7.6: Distributed Case Database- Restoring Cases Workaround
FTK 7.6 allows users to utilise multiple case databases, allowing for cases to be distributed using round robin.  However, when restoring cases using DBCon...
Fri, Jun 23, 2023 at 1:41 PM
Change the default PGDATA directory
Problem Data folder for the postgres database needs to be moved.    Resolution Step 1: Stop The PostgreSQL Service Close all application that are curre...
Fri, Jun 23, 2023 at 1:40 PM
How to Rebuild SQL Indexes Via A Maintenance Plan
Question How do I rebuild my SQL indexes using a maintenance plan?   Answer Open up SQL Server Management Studio. Expand out "Management&qu...
Fri, Jun 23, 2023 at 1:40 PM
Error 1920 while installing PostgreSQL
Symptom: You get error 1920 or other errors while installing PosgreSQL. Resolution: Verify the PostgreSQL/FTK ISO's MD5 with the on listed on the Dow...
Fri, Jun 23, 2023 at 1:39 PM
Change the 'sa' password in MSSQL
Question How can I change the 'sa' password in MSSQL?   Answer Open SQL Server Management Studio Log in to SQL using "Windows Authe...
Fri, Jun 23, 2023 at 1:38 PM