salisburyproject wrote:

>
>
> Supposed I can give up on the bad pages. How can I make the rest of
> the database available?

You probably can't give up on the bad pages, because one of them is
almost certainly a transaction inventory page.

> Isn't gfix supposed to fix the data found on disk?

Yes, but it doesn't have any way to guess which transactions should be
committed and which should not.

> Is there another tool I can use?

Not anything open source. IBSurgeon.com has a tool that may be able to
fix the problem.

>
> I consider database maintenance a crucial issue, even in cases of
> hard shutdown... If I can't rely that most of the data can be
> recovered, than may be Firebird isn't right choice?...

As long as forced writes are enabled, the database should survive a hard
shutdown. I've seen a recent case that suggests that there is a bug in
the handling of back version pointers in that case, but gfix will
correct that problem.

Regards,


Ann