lagg2007
asked on
Corrupt Firebird Database
Im in a bit of a pickle. My client has not be running his backups and called me today with an error on his software. On closer inspection ive found that the database is corrupt. Its a firebird database. Gfix cant repair it. The erro message I get is "database file appears corrupt ()
-bad checksum
-checksum error on database page 2
Does anyone know of a soluion for the error? any software package to repair?
-bad checksum
-checksum error on database page 2
Does anyone know of a soluion for the error? any software package to repair?
ASKER
Thank you for your help. I had found this tool not long before I got your message. Would you recommend? We have got a quote fom an ibexpert for a repair, but we have a lot of these databases out and if this package were to sort out the issue it would make more sense financially.
I haven't used it myself but have heard good reports, the tool may not be able to fix your issue
you need to determine "why" the corruption has occurred as well
ASKER
How is it possible to determine the cause? I would have thought it was improper shutdown of the database server?
run out of disk space is another, I managed to corrupt a database last week by changing the hostname while it was running
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
http://www.ibphoenix.com/main.nfs?a=ibphoenix&s=1241514005:21347&page=ibp_firstaid