On Thu, Sep 4, 2008 at 1:11 PM, Charlie Coleman <[EMAIL PROTECTED]> wrote: > At 01:02 PM 9/4/2008 -0400, MB Software Solutions General Account wrote: >>On Thu, September 4, 2008 1:48 pm, Charlie Coleman wrote: >> > Nah, the MS evangelicals are having meetings all month, trying to figure >> > out a way to save the company. I got the memo (not sure why though, I >> > removed myself from their "fanatics" list many years ago - I suppose SQL >> > Server screwed things up... again). >> >>Come on, Charlie...let's be fair. Which do you think would have more >>issues typically: the SQL Server database or the equivalent Fox database? >> Most would say the latter (due to corruption, invalid memo, etc.). IF >>ITS CONFIGURED CORRECTLY, I would expect SQL Server to perform reliably >>and well. > > Well, I can only go on my experience. I've had more problems from SQL > Server than I ever have had with VFP. I've got a couple systems that work > with SQL Server to store data: but guess what, I duplicate all that data in > a VFP database as well. Thank God I did, I've been able to restore the SQL > DB about 3 times in the past 5 years when it had major problems. ---------------------------------------
Probbaly a hardware issue. In just about 11 years of SQL Server experience I can say that I have only had one restore a DB issue. The RAID went south, and all but one of 8 disks were red. There was a backup on another server on the LAN so just a PITA to identify a bad RAID, wait on more drives, replace RAID, Slap in new drives, configure it for performance, restore SQL2000. In my FP/VFP years the problems were all on tiny companys where they didn't have a lan/server, only a workstation or a few workstations. These tiny shops were where data corruption became a reality. Memo fields that were shot after a power fluctuation. Bad power or someone breaking the service nearby because of hitting the pole on the street nearby. -- Stephen Russell Sr. Production Systems Programmer Mimeo.com Memphis TN 901.246-0159 _______________________________________________ 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.
