Subject Re: [firebird-support] Database Corrupted
Author Ann W. Harrison
Marco Parmeggiani wrote:
>
> it's a matter of pumping the data in another database or there's some
> voodoo magic they can do to solve the problem losing less data?
>

Voodoo is the right way to go here. Using the tools they have
developed, the people at ibsurgeon can dump the contents of system table
data pages to tell them what type of page is missing. In all
likelihood, one of the pages that's missing is a transaction inventory
page. They'll create a new one, marking all transactions up to the
"next transaction" from the header page as committed. Then they can
figure out what else wasn't written, and create enough of the structure
of those pages that the database can be backed up.

Regards,


Ann