community.borland.com

Article #25581: What Causes Database Corruption?

Problem:
What are the known possible causes for database corruption?

Solution:
The information in this article applies to:
* All Versions

Here are some things that can cause InterBase to crash leading to corruption:

1. Poorly written UDFs-listed first and also the number one cause.
2. Altering metadata while other users are connected and working with the database.
3. Making an OS copy of the database while other users are connected.
4. System crashes-some OS's are more stable than others
5. Out of band (OOB) data - Potentally a problem specific to NT SP 3
6. The use of Delphi's Event Alerter component can produce OOB.
7. Power outages-implement a UPS (Uninteruptable Power Supply).
8. InterBase engine errors (InterBase Bugs).


Last Modified: 26-OCT-00