I have to agree with Razzak. I used to use the netgear pro-safe switches and my database would get corrupt from time to time(about once every 3-6 months).
I switched to 3com switches late last year and have not had one corruption since.... Here are some other things I found over the years to minimize corruption. 1. Turn off power saving on the nics. Go into the nic's properties. 2. Put every switch on an ups. 3. Use a timeout on my apps. 4. Disconnect from the db in the app. 5. Most important. Have a backup plan in place!! Dan Goldberg -----Original Message----- From: [email protected] [mailto:[EMAIL PROTECTED] On Behalf Of A. Razzak Memon Sent: Thursday, September 25, 2008 10:12 AM To: RBASE-L Mailing List Subject: [RBASE-L] - Re: Networks At 12:55 PM 9/25/2008, jan johansen wrote: >Is there a situation that any one can think of that would corrupt >forms/reports or is it just one of those things? Jan, In a multi-user network environment, a bad NIC, poor network wiring, cheap routers/switches and electric surge are the primary cause of data corruption, including SYS_ table(s). You wouldn't see such behavior in a stand-alone environment, when a database is connected on a local machine. You may also need to make sure that all users connected to the same database are in sync as far as the R:BASE version and build is concerned. This is one of the biggest challenge for network administrators and our lovely R:Developers. Hope that gives you some blues clues ... Very Best R:egards, Razzak.
