Subject Re: [ib-support] Database corrupted
Author Artur Anjos
And just two cents more:

Have them buying UPS's to the servers. They are cheap in this days, and I
really don't understand why people don't spend money with that.

There are times that a small and cheap piece of hardware could save
developers & clients lots of time & money.

Artur

----- Original Message -----
From: "Paul Reeves" <paul@...>
To: <ib-support@yahoogroups.com>
Sent: Monday, May 13, 2002 5:12 PM
Subject: Re: [ib-support] Database corrupted


> On Mon, 13 May 2002 11:44:21 -0300, Roberto de Amorim wrote:
> >Hi all,
> >
> >I have been being sad with the Interbase's results... My application
> >is used in 642 companies and almost everyday I receive a bad notice
> >that the database in corrupted in one of them...
>
> [snipped]
>
> >I'm using Delphi 5, IB6, Asta 4.6 with IBXServer and it occurs
> >usually in lacks of energy.
>
> If you mean after there has been a power failure then the solution is
simple. Write a little batch file that will call gfix to set forced writes
to ON. Get all of your customers to run it. Your customers will no longer
experience this problem.
>
> InterBase 6 was shipped to create databases with forced writes OFF by
default. This almost always leads to corruption under Win32 if the power
fails. Firebird 1.0 creates new databases with Forced Writes ON by default
under windows. However, although I would recommend that you upgrade to
Firebird the upgrade will not change the forced writes setting of an
existing database.
>
>
> Paul
> --
> Paul Reeves
> http://www.ibphoenix.com
> Supporting users of Firebird and InterBase
>
>