Subject Re: [firebird-support] Odd problem - inconsistent result set
Author Milan Babuskov
Sergio H. Gonzalez wrote:
> Sorry about the intromission... but I'd like to ask some questions on this
> matter:
> 1) How can a FB index be damaged? I didn't know that was a risk in FB...

I've seen it happen about once a year on each of my databases that have
forced-writes OFF.

> 2) It works in the same way that DBFs ? I mean: a bad index can cause bad
> resuls?

Yes, if the query uses that index.

> 3) It is possibble for the engine to tell if there is a bad index?

You can use gfix to find those easily. Or do you mean at run-time when
you start the query that uses it?

>> Does you did backup\restore circle for this database ?
> 1) Is there any "correct" way to do this?

I believe he asked you that because backup+restore fixes all broken indexes.

> I do it with a .BAT file, and rename the restored database to the
> original one. Would you be so kind to show how do you do it? And how often?

It all depends on the amount of data you can affort to lose. For
example, if you can afford to lose one day's worth of changes in the
database, then do backup once per day.

Milan Babuskov