Firebird database-corruption and what you can do about it

There are usually only two reasons why a database can be corrupted in Firebird: 1) You copied the fdb-file while the Server was accessing it and 2) You don’t have forced writes enabled and the server shut down unexpectedly (e.g. power-outage)

Database recovery is done in four steps. Here’s how you do it:

1 Star2 Stars3 Stars4 Stars5 Stars (2 votes, average: 5.00 out of 5)

One comment

  • hmm, how many interesting things…

    1. never do backup on the broken database without -g option. Otherwise, during backup server will initiate garbage collection, and backup can fail, if version chains are broken.

    2. never use -c -r options both. This is oxymoron, and if you specify database name the same as existing, you will loose it (by -r option). Also -r do not work anymore in Firebird 2.x.

Leave a Reply