Error Message
“Table Corrupt Other Than Header” …
“Corrupt File Other Than Header” …
Explanation of Error
The BDE has found an inconsistency in the data portion of the DB file (which also contains the Header information - hence the poorly named error message).
Severity
High. The chance for data loss is moderate to high. Corruption in the DB file may result in the loss of sections of the table during the rebuild process. All rebuilt tables should be checked for completeness after rebuilding. (Comparing file size of the DB and MB is a good place to start. Then examine the first and last records and confirm the modified date seems correct.)
Resolution
- The primary fix for this issue is to use the dbrebuild utility to scan and rebuild the affected table.
- The entire data drive should be checked for corrupted sectors as this could be an indicator of a failing harddrive.
- In rare cases, the indexes will be lost (removed) during the rebuild process. In this cases, it will be required to manually delete the indexes and insert the data into a new table with indexes. See Manually Rebuilding SMS Tables
- Another option when dbrebuild fails is the Borland Database Desktop utility. It uses the same DLL as the dbrebuild Utility but for reasons unknown is slightly better at salvaging databases with corrupted data.
Possible Root Cause(s)
This data most common occurs when the drive was interrupted with a reset, power-failure, power-off, or CTRL-ALT-DEL in the middle of writing the file. Similarly, a bad disc sector when writing/reading from the file will also produce the same result. Cyrious does not think a network outage will result in this error (unconfirmed).