Subject Re: [firebird-support] Embedded server database easily corrupted
Author Da Jiao
Hi,

> First, power-offs (exspecially multiple) are a sign that something is
wrong.
> Is the user turning off his system by some power switch instead of
shutting
> it down? Investigate this.

All happened on the customers' desktops. power-off is just a guess and there
are too many factors out of our control.

> Second, disable write-back-caching in your OS. Database servers are
designed
> to keep information intact, if the system is powered off at any time.
> (Therefor power-offs should only lead to loss of the information that was
> changed during power-off.) As someone on this list stated, embedded server
> is behaves similar to superserver - except to missing multiclient and
> multithread support. It should handle such conditions just fine.

How to disable write-back-caching? It is not only loss of data but corrupted
db file, and the same thing does not happen often for superserver version.
There got be some differences between these two.
Thanks.