Repair corrupted firebird database
If Firebird database is corrupted, please follow these steps to fix it:
- Stop
Firebird server. Don't use corrupted database - it leads to further
corruption. Also, do not copy Firebird database when Firebird server is
running - it leads to corrupted copy and, sometimes, to corrupted
original database.
- Make a copy of Firebird database. Always keep original copy of corrupted Firebird database for possible future use.
- Start Firebird server and run the following commands:gfix.exe -v -full -user SYSDBA -pass masterkey path_to_your_databasegfix.exe -mend -user SYSDBA -pass masterkey path_to_your_databasegbak -b -v -user SYSDBA -pass masterkey path_to_your_database path_to_backupTry to run them all, even if gfix shows errors.
- If backup completed successfully, restore database:gbak -c -v -user SYSDBA -pass masterkey path_to_backup path_to_database
- If gbak fails, download FirstAID Diagnostician, install it and run Diagnose on original corrupted database. Send full error text (or screenshot) and diagnostics log to IBSurgeon Support support@ib-aid.com.