Subject Re: [firebird-support] Corrupted database
Author Geoff Worboys
> You could also try DBak, which is freeware and has a rebuild
> option. You may lose some records.

> Just yesterday I had a database which gbak and gfix couldnt
> fix and dbak was able to get almost all the data back. Nice.
> You do need to say ignore all errors or some such switch.

> Thanx to Geoff Worboys for this lifesaver.

I am really pleased to hear that it has been of use. I have
not had much feedback for a long time, so it has been difficult
to know whether it works for others as well as it works for me.

> As an aside - though lot of people vigorously protest that
> Firebird databases dont get corrupted. IT HAPPENS.

I have not had any problems with recent versions of FB, but I
do not yet have it in widespread use. Certainly the earlier
versions had problems with blobs (at least), which is why there
is a specific option in DBak to ignore blob errors. It does
pretty much what Ann describes but on an automated basis.

In the cases where blobs are corrupt, you get everything back
except the corrupt blob. The rest of the record and any other
blobs in the same record should be restored, and the log should
give you details of the error that it found including output of
the readable row details - allowing you to see what record was
impacted by the error, in the hope that the problem can be
corrected manually on the restored database.

Geoff Worboys
Telesis Computing