David, Why do you feel that it is necessary to pack keys every day. Is this a signal that you suspect the "Industrial Strength" engine has a problem? I have one customer that has corruption repeatedly and I can't get to the bottom of it. I tried Pack Keys once and it didn't help. They are running dos and win 6.5++ 1.851 We've tried rotating the unuse (if there is such a word) of workstations to see if one of them is causing the problem. No positive results so far.
Bernie Lis Megabytes, Inc. ----- Original Message ----- From: "David M. Blocker" <[EMAIL PROTECTED]> To: <[EMAIL PROTECTED]> Sent: Wednesday, August 21, 2002 9:07 AM Subject: Re: Corrupt Indexes > Because of the importance of indexes, the DAILY backup routine that I have > all my clients do does the following: > > SET MULTI OFF > CONNECT dbname > - abort if you can't connect > AUTOCHK dbname > - abort if problem > PACK KEYS (rebuilds all indexes) > COPY .... (backup) > > David Blocker ================================================ TO SEE MESSAGE POSTING GUIDELINES: Send a plain text email to [EMAIL PROTECTED] In the message body, put just two words: INTRO rbase-l ================================================ TO UNSUBSCRIBE: send a plain text email to [EMAIL PROTECTED] In the message body, put just two words: UNSUBSCRIBE rbase-l ================================================ TO SEARCH ARCHIVES: http://www.mail-archive.com/rbase-l%40sonetmail.com/
