Subject Re: gfix questions
Author diwic2
--- In, "heineferreira"
<heineferreira@...> wrote:
> Hi
> I haven't had a corrupt firebird database but I was wondering how
> gfix is? A friend of mine who has over a hundred customers who all
> firebird says that he insists that his customers install ups'es and
> 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