Repair corrupted firebird database

Repair corrupted firebird database

If Firebird database is corrupted, please follow these steps to fix it:
  1. 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.
  2. Make a copy of Firebird database. Always keep original copy of corrupted Firebird database for possible future use.
  3. Start Firebird server and run the following commands:
    gfix.exe -v -full -user SYSDBA -pass masterkey path_to_your_database
    gfix.exe -mend -user SYSDBA -pass masterkey path_to_your_database
    gbak -b -v -user SYSDBA -pass masterkey path_to_your_database path_to_backup

    Try to run them all, even if gfix shows errors.
  4. If backup completed successfully, restore database:
    gbak -c -v -user SYSDBA -pass masterkey path_to_backup path_to_database
  5. 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.