Subject Re: [firebird-support] Securing database against corruption on systems that suddenly get turned off
Author Christian Gütter
Hi,

> We have FirebirdSQL (2.1) running on a client computer (Windows).
> This client has some problems with his power grid which causes the
> PC to suddenly and unexpectedly shut down in infrequent intervals
> (usually once or twice per day). Most of the time this doesn’t
> cause any problems, but once in a while this causes the database to be corrupted.
>
> I’m not at all surprised that the database gets corrupted like this
> (as turning off a computer without shutting everything down gracefully can have that effect).

you should at least turn on forced writes so that changes are written to the disk immediately (just in case you have not already done that).



Cheers,
Christian