Subject RE: [firebird-support] Corrupt database
Author Brenden Walker
> -----Original Message-----
> From: firebird-support@yahoogroups.com
> [mailto:firebird-support@yahoogroups.com] On Behalf Of Robert martin
> Sent: Thursday, September 20, 2007 7:04 PM
> To: firebird-support@yahoogroups.com
> Subject: [firebird-support] Corrupt database
>
> Hi
>
<snip>
> I tried Gfix -two_phase (Just ready to try anything) This
> returned no errors but a further gBak failed anyway.
>
> What are peoples other suggestions? The most recent backup
> they have is
> 2 days old. There backups have been failing and they have
> not noticed.

You could try IBDBRepair:

http://sourceforge.net/projects/ibdbrepair

It attempts to re-create your database, pumping the data from the
corrupt DB to a new fresh DB (created from metadata of the existing db).
This should be able to recover all data that is recoverable.

It's a long process though, depending on the database structure.