Subject | Re: Fix corrupted database |
---|---|
Author | will.honor |
Post date | 2006-12-06T08:49:53Z |
> ERROR: page 87361 is of wrong type (expected 7, found 5)Myles,
It looks like you have stumbled on the same bug as some others on
this group. You should read these previous threads for some
background. What machine do you have? and are you using Classic or
Superserver?
FB 1.5 - Continuing database corruption issues
http://tech.groups.yahoo.com/group/firebird-support/message/81090
Corruption in Firebird Classic 1.5.3.4870
http://tech.groups.yahoo.com/group/firebird-support/message/81723
Do you still have a copy of the original corrupted database before
running Gfix -mend on it? If so would you be willing to send it to Ann
Harrison as requested in this message :-
http://tech.groups.yahoo.com/group/firebird-support/message/81876
In terms of fixing the database there have been a few solutions
suggested in the threads I mentioned above but I will detail the
solution that works for me.
Sometimes you dont need to run gfix -mend so first try :
1.) Make a copy of the corrupt database!
2.) gbak.exe -B -V -ig -G
3.) Restore as normal.
If that fails then try :
1.) Make a copy of the corrupt database!
2.) gfix -mend
3.) gbak.exe -B -V -ig -G
4.) Restore as normal.
Hope this helps.
Regards,
Will