>Good advice. One question. Do you use reindex or recreate the index tags? I prefer the latter as if there is in fact an index that has been corrupted reindex will not solve the problem, at least not for me.
Actually, last time I had an index corruption I used PACK.
On the other hand, I make all changes to the database first to an empty copy of the database, that is, one that has all tables with zero records. Then, I can update the structure for the production data, issuing APPEND FROM for each table. I use TaxRI, and disable referential integrity for each table while it is being updated.
In case the production database goes awry, I can always overwrite from my empty structure. Perhaps I have already overwritten corrupt indices with good ones this way, without noticing, just because I updated the table structure.
Hilmar.
Difference in opinions hath cost many millions of lives: for instance, whether flesh be bread, or bread be flesh; whether whistling be a vice or a virtue; whether it be better to kiss a post, or throw it into the fire... (from Gulliver's Travels)