Subject RE: [firebird-support] Securing database against corruption on systems that suddenly get turned off
Author Glenn Thomas Hvidsten
Where do I find that setting?

Glenn Thomas Hvidsten

From: firebird-support@yahoogroups.com [mailto:firebird-support@yahoogroups.com]
Sent: 21. september 2015 13:21
To: Glenn Thomas Hvidsten glhv@... [firebird-support] <firebird-support@yahoogroups.com>
Subject: Re: [firebird-support] Securing database against corruption on systems that suddenly get turned off



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


****************************************************************************
Denne epost har blitt kontrollert for virus av Comendo Norge AS
This e-mail has been scanned for viruses by http://www.comendo.no
****************************************************************************


[Non-text portions of this message have been removed]