Subject Re: Crash corrupted database file
Author Felix
--- In firebird-support@yahoogroups.com, Dimitry Sibiryakov <sd@...> wrote:
>
> > The key point is that Firebird is ACID compliant so a bluescreen should not be able to upset the database file. There must be a small weakness in the Firebird code somewhere I wonder if there is a bug logged against this?
>
> DBMS ACID can't help you if OS I/O system drop buffers into random
> places on HDD, messing database file at low level.
>
> SY, SD.
>

Yes, that makes sense.

I suspect if I ran the right query in flamerobin I could get an error. Select all on each table doesn't seem to find the problem though.

Is there any file validation and recovery that can be done programatically? An embedded gfix api?