Abstract: Known Causes of Corruption in InterBase Databases
by Craig Stuntz
InterBase is, in general, a very stable database server and corruption is rare. When corruption does occur, then, it is important to determine the cause of the corruption, because it indicates that something is wrong with the installation and it is important to fix it. Database corruption should not be a routine occurance, even if a customer neglects to maintain the DB.
It is a good idea to run Database Validation or command-line gfix from time to time so that if corruption does occur it can be caught early, before the damage to database is too severe to repair.
As an aid to diagnosing source of the problem, the table below lists known causes of InterBase database corruption, along with suggestions for how to avoid each type of corruption in the future. To repair a corrupt database, use command-line gfix with the -mend switch, or Database Validation in IBConsole. If that fails, restore from a recent backup or post a question to the borland.public.interbase.general newsgroup.
Thanks to Alexey Kovyazin, Bj�rge S�ther, Thomas Steinmaurer, and Quinn Wildman for feedback on this article.
Copyright © 2002 by Craig Stuntz. All rights reserved.