Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Is there a way to prevent data lost or data corruption?
Message
From
26/11/2006 02:12:42
John Ryan
Captain-Cooker Appreciation Society
Taumata Whakatangi ..., New Zealand
 
 
To
25/11/2006 03:38:47
General information
Forum:
Visual FoxPro
Category:
Other
Environment versions
Visual FoxPro:
VFP 9
OS:
Windows XP
Network:
Windows 2003 Server
Database:
Visual FoxPro
Miscellaneous
Thread ID:
01172197
Message ID:
01172449
Views:
16
except for a HD failure and software bugs, SQL SERVER don't lose data

Yes, I've used SQL Server for over a decade and have been highly inpressed with its stability.

But I've also seen data loss on flaky networks with PC freezes. If there are issues on the PC or between the PC and the server, converting to SQL Server will not fix those. A data entry clerk can carefully enter a scrreen of complex data, then the #$^$^%$$^ PC freezes again and the work is lost. You need to fix whatever is causing the freezes.

This isn't an argument against SQL Server. It is an argument for investigating the cause of the freezing, not just changing database which seemed to be the proposed solution at the start of the thread.
"... They ne'er cared for us
yet: suffer us to famish, and their store-houses
crammed with grain; make edicts for usury, to
support usurers; repeal daily any wholesome act
established against the rich, and provide more
piercing statutes daily, to chain up and restrain
the poor. If the wars eat us not up, they will; and
there's all the love they bear us.
"
-- Shakespeare: Coriolanus, Act 1, scene 1
Previous
Next
Reply
Map
View

Click here to load this message in the networking platform