We reindex our databases every night and it has seemed to make many issues go away.
--- On Tue, 12/9/08, Fred Taylor <[EMAIL PROTECTED]> wrote: From: Fred Taylor <[EMAIL PROTECTED]> Subject: Re: VFP index corruption To: "ProFox Email List" <[email protected]> Date: Tuesday, December 9, 2008, 3:35 PM No, the size should only be an issue if the .CDX file goes over the 2GB boundary. Fred On Tue, Dec 9, 2008 at 12:43 PM, Jean Haidar <[EMAIL PROTECTED]> wrote: > the size of the .DBF is 1.1 gig and the cdx is 158 Mg > that would be be an issue? > > Jean > > > ________________________________ > From: Fred Taylor <[EMAIL PROTECTED]> > To: [EMAIL PROTECTED] > Sent: Tuesday, December 9, 2008 1:15:22 PM > Subject: Re: VFP index corruption > > Make sure the size of your .CDX file isn't the issue. With 29 tags and > that > much data in the table, you may have gone over the 2GB file limit. > > Fred > > > On Tue, Dec 9, 2008 at 12:11 PM, Jean Haidar <[EMAIL PROTECTED] > >wrote: > > > The data reside on Citrix Server and it is not eady to request changes > from > > the Citrix Team? > > > > we are rebuilding the index every few days > > > > If it is a bad block? don't you think this error would pop up in > > another Index File or some other DBF file? > > > > Thanks, > > Jean > > > > > > ________________________________ > > From: Michael Madigan <[EMAIL PROTECTED]> > > To: [EMAIL PROTECTED] > > Sent: Tuesday, December 9, 2008 12:57:11 PM > > Subject: Re: VFP index corruption > > > > 1. Check the event log of the computer that holds the data to see that > > there are no bad blocks or other disk problems in the event logs. > > > > 2. Make sure opportunistic locking is turned off on the server. > > > > 3. Run scan disk > > > > > > [excessive quoting removed by server] _______________________________________________ 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.
