community.borland.com
Article #29869: Repairing a corrupt database
Question:
My database is corrupt, what do I do?
Answer:
Validate, then backup and restore your database using either the command line tools, gfix and gbak, or the GUI tool, IBConsole.
To use command line tools:
- First make a copy of your database. Shut down the database and then make an operating system copy of it (gbak will not be able to copy a corrupt database.)
- Run the gfix utility against the database using the -mend switch.
- Backup and restore your database using gbak.
To use IBConsole:
(This assumes that your server and database are already registered in IBConsole.)
- First make a copy of your database. Shut down the database and then make an operating system copy of it (gbak will not be able to copy a corrupt database.)
- Connect to the server.
- Do not connect to your database, but do hight light it in the left hand pane.
- Choose Tools | Validate.
- If validate finds errors, chose Repiar.
- (You may have to perform the previous two steps more than once.)
- Finally choose Tools | Backup & Restore.
For more information on using these tools see your "InterBase Operations Guide". Information on repairing a database is in the "Database Configuration and Maintenance" chapter. Information on backing up your database is in the "Database Backup and Restore" chapter.
If these steps do not correct the problem, you will likely need to contact a data recovery service. One company that provides this service is DevRace. (Please note: Borland does not vouch for or guaranteee the services provided by Devrace.)
Last Modified: 27-MAR-03