Subject | Re: [firebird-support] Securing database against corruption on systems that suddenly get turned off |
---|---|
Author | Christian Gütter |
Post date | 2015-09-21T11:21:16Z |
Hi,
Cheers,
Christian
> We have FirebirdSQL (2.1) running on a client computer (Windows).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).
> 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).
Cheers,
Christian