MailStore Home - Tips and Tricks - Part 4 - Manual repair corrupted MailStoreFileGroup.fdb files and .fdb backup

Problem:

"The problem occurred when moving my back-up to a new location. Somehow the MailStoreFileGroup.fdb file got corrupted. To cut to the chase is there a way to manually repair the file for my latest database back-up is to old for my comfort. I would rather repair the database and have excess to all my archived mails including the including the possibility of it going wrong. Then on forehand back up from an older back-up and missing those essential mails."

Resolution:

Thanks to MailStore Community powered support:

"First of all, close MailStore Home. Then open the cmd.exe by using the Start -> Run.. function in Windows. Now go on with the following instructions. We assume you are already in the directory containing the MailStoreFileGroup.fdb file.

1. Define the following two variables, it makes life easier, in that you do not have to type in the user name and password every time you issue a command. 

SET ISC_USER=SYSDBA 
SET ISC_PASSWORD=masterkey 

2. Always make sure you work on a copy of the database, not the production database. Use the operating system to make a copy of the database. You must have exclusive access to the database to do this. 

copy MailStoreFileGroup.fdb MailStoreFileGroup.fdb.bak 

3. Now check for database corruption. You must have exclusive access to do this, but since you're working on a copy of the original database, this is not a problem..."

See full post here

Useful links:
- Firebird Gfix
- Firebird Gbak