Well,

thanks and.. excuse me for insisting on this:
Is it true that if I don't get the paid support from the site you
mention, there is no tool that can help me recover the database?..

If so, the whole idea of open source and free DB solution is
meaningless..

Forced writes are may be secure and ensure data consistency in such
cases, but you pay in performance. The DB should be capable to
recover valid records and inform what records/pages are lost.. Basic
requirement from a database, I guess...

The physical file is still there. So there MUST be some tool that is
capable to 'walk' it, analyze and fix - for instance gfix does so
with the -i option. If the checksum is 'fake', then DBA must be
capable to decide to rollback the DB to the 'last known safe state'.
Even for the price of loosing open transactions, but not the ENTIRE
data.

Am I wrong assuming that FB doesn't support this? (Hope I am!)

Thanks for the answers...

Kiril.

--- In firebird-support@yahoogroups.com, "Ann W. Harrison"
<aharrison@i...> wrote:

> 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