Ed Leafe wrote: > On Sep 27, 2007, at 8:24 AM, Paul Newton wrote: > >> Secondly, I am getting 1561 errors (Database is invalid) associated >> with >> certain commands (DELETE TAG, INDEX ON) when/after deleting the >> table CDX. >> >> Can I safely ignore these errors or should I trap them and use >> VALIDATE >> DATABASE ... RETRY in the error handler ? > > You should not delete the CDX. The DBC expects it to be there, as > index info is stored in the DBC. Always use the appropriate commands, > such as DELETE TAG ALL, to remove indexes.
I feel that my scheme has proven to be quite bulletproof over the years: 1) copy file * to (backupDir) 2) issue CREATE DATABASE and CREATE TABLE statements to create a new, empty data structure for every database and table. 3) append from the backed-up data 4) issue INDEX ON statements for the new tables Checks for prior record count versus new record count could show potential problems, etc. Controlling the process yourself gives you fallback every step of the way. Could very well be that all I've ever needed to do is DELETE TAG ALL and then recreate the indexes, but with my scheme I know that everything is getting built up from scratch... YMMV -- pkm ~ http://paulmcnett.com _______________________________________________ Post Messages to: [email protected] Subscription Maintenance: http://leafe.com/mailman/listinfo/profox OT-free version of this list: http://leafe.com/mailman/listinfo/profoxtech Searchable Archive: http://leafe.com/archives/search/profox This message: http://leafe.com/archives/byMID/profox/[EMAIL PROTECTED] ** All postings, unless explicitly stated otherwise, are the opinions of the author, and do not constitute legal or medical advice. This statement is added to the messages for those lawyers who are too stupid to see the obvious.
