Subject Re: gfix questions
Author diwic2
--- In firebird-support@yahoogroups.com, "heineferreira"
<heineferreira@...> wrote:
>
> Hi
>
> I haven't had a corrupt firebird database but I was wondering how
good
> gfix is? A friend of mine who has over a hundred customers who all
use
> firebird says that he insists that his customers install ups'es and
he
> says that he never even had one corrupt database.
> Do firebird databases only become corrupt during power failures?
>
> Heine Ferreira
>

The introduction paper tells what you should and shouldn't do to
keep your data safe. In short:

- Do not allow any other program (including automatic backups) to
touch the database file
- Do not modify the system tables (reading them is OK)
- Do not run out of disk space
- Do not disable "forced writes"

My limited experience says that gfix works in approx half of the
cases.