General information
Category:
Databases,Tables, Views, Indexing and SQL syntax
Environment versions
Network:
Windows 2003 Server
>>We continue to get an increasing number of these errors over a period even though the index is not corrupted...
>>Error: 2066 - Index file "h:\ht\quids\data\jitems.cdx" is corrupted. Please rebuild it.
>>
>>The table has approx 2.3 million records has 8 index tags including one on deleted. There are only 200 deleted records. There are large numbers of transactions on this file every day, perhaps 50,000 or so. It's not that huge in terms of disk space, 470MB for the dbf and 95 MB for the CDX.
>>
>>300 users, and we get perhaps 20 errors per day.
>>
>>Any ideas folks?
>
>By "rebuild", are you simply REINDEXing, or are you actually deleting/recreating the tags? The former won't fix subtle corruptions.
>
>One relatively painless way to "recreate" the tags is to overwrite the production .CDX with a known good one (even if it's old or has no records), then REINDEX. This can save some pain that can occur with DELETE TAG ALL if you have relations or other RI defined on that table in a VFP database.
We completely rebuild the indexes. The index isn't corrupted. The error message is in error. Fox must be struggling to keep the index updated for some reason.
Previous
Next
Reply
View the map of this thread
View the map of this thread starting from this message only
View all messages of this thread
View all messages of this thread starting from this message only