Subject Re: Repeated Index Corruption
Author emb_blaster
--- In firebird-support@yahoogroups.com, "Maya Opperman" <maya@...> wrote:
>
> Hi All,
>
> If I validate the dodgy database, I get the following message:
>
> Summary of validation errors
>
> Number of index page errors : 477
>
> IBE: Validation completed.
>
> Sweeping, validating, fixing, either shows this error, or says
> everything is fine, but does not seem to fix the problem till a backup/
> restore is done.
>

hello!

AFAIK, validating and fixing is a prepares to backup/restore. If you did it (like gfix -mend) you will need a backup/restore after. So it will not works before that. Or at least it is a good pratice to do...

How much is the load of your server?