DelphiFAQ Home Search:

Fixing a broken GDB file

 

commentsThis article has not been rated yet. After reading, feel free to leave comments and rate it.

Question:

My *.gdb file is damaged. When I run gfix, I get this error message:

database file appears corrupt ()
-wrong page type
-page 469 is of wrong type (expected 3, found 0)


I tried -mend, -full etc. all the combinations, but no luck with the *.gdb file. Can I ignore broken pages with gfix from my GDB file, so that I can rescue as much data as I can? I really need that data.

Answer:

  1. make a safety bulk *.gdb file backup. You should shutdown IBServer for that. Always make copies of the .GDB and/or backups. It can be done without shutting down the interbase server, but it's not 100% safe.
  2. There is no way to use gfix to ignore the bad page. So to get to as much data as possible: Do a metadata only backup. Restore that to a new database. Use a data pump to pump data from the damaged database to this restored database.


Alternatively, you can contact the folks at www.ib-aid.com and see if they can fix the database manually.


Comments:

2016-11-15, 07:54:50
anonymous from Iran  

 

 

NEW: Optional: Register   Login
Email address (not necessary):

Rate as
Hide my email when showing my comment.
Please notify me once a day about new comments on this topic.
Please provide a valid email address if you select this option, or post under a registered account.
 

Show city and country
Show country only
Hide my location
You can mark text as 'quoted' by putting [quote] .. [/quote] around it.
Please type in the code:

Please do not post inappropriate pictures. Inappropriate pictures include pictures of minors and nudity.
The owner of this web site reserves the right to delete such material.

photo Add a picture: