Subject | RE: [firebird-support] Corrupt database |
---|---|
Author | Brenden Walker |
Post date | 2007-09-21T19:57:02Z |
> -----Original Message-----<snip>
> 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
>
> I tried Gfix -two_phase (Just ready to try anything) ThisYou could try IBDBRepair:
> 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.
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.