Atola Insight Forensic: Database backup and restore
To be able to backup and restore Atola Insight Forensic database, you will need Microsoft SQL Server Management Studio Express. You can download it here.
Backup
To backup the database, please follow these steps:
- Launch Microsoft SQL Server Management Studio Express.
- Establish database connection (with default settings).
- Select Databases folder on the tree.
- Right-click AtolaInsightForensic and select Tasks > Back Up.
- Check the backup destination and change it if desired.
- Click OK.
Restore
This procedure will work only if you did not move backup file (for example, from another PC). If you are moving the database over to another PC, see Restore when moving.
- Launch Microsoft SQL Server Management Studio Express.
- Establish database connection (with default settings).
- Select Databases folder on the tree.
- Right-click AtolaInsightForensic and select Tasks > Restore > Database.
- Select the desired backup file.
- Click OK.
Move
To move the database from one PC over to another, please follow these steps:
- Backup your database on the source PC.
- Copy backup file over to destination PC.
- Restore the backup file on the destination PC (see Restore when moving below).
Restore when moving
- Launch Microsoft SQL Server Management Studio Express.
- Establish database connection (with default settings).
- Right-click Databases folder on the tree and select Restore Database.
- In the To database field enter AtolaInsightForensic.
- In Source for restore, select From device.
- Point to the database backup file.
- Click OK.
If you only have .mdf and .ldf files
This may happen if your operating system has crashed and you are reinstalling everything from scratch. In this case you would need to copy AtolaInsightForensic.mdf and AtolaInsightForensic_log.LDF files from the old hard drive over to the new one. You may find these files in:
- "C:\Users\*USERNAME*\AppData\Roaming\Atola\Insight Forensic\", if (localdb)\V11.0 instance is used (default).
- "C:\Program Files\Microsoft SQL Server\MSSQL.1\MSSQL\Data\", if SQLEXPRESS instance is used.
After you have copied the database files, follow these steps:
- Launch Microsoft SQL Server Management Studio Express.
- Establish database connection (with default settings).
- Right-click Databases folder on the tree and select Attach.
- Click Add and select AtolaInsightForensic.mdf.
- Click OK.