Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Chance of lost data versus chance of corrupt data
Message
From
25/02/2003 16:13:02
 
 
To
25/02/2003 09:54:41
Cindy Winegarden
Duke University Medical Center
Durham, North Carolina, United States
General information
Forum:
Visual FoxPro
Category:
Other
Miscellaneous
Thread ID:
00757170
Message ID:
00757791
Views:
8
>>Without addressing your question, the real answer is for the backup process to notify users that have files open 2 minutes or so before it kills their connections - or, failing that, send a broadcast message to all w/s that may be running and logged in. That lets interactive users shut down gracefully; non-interactive or unattended processes will still get killed ungracefully - but that's no different from what's happening now.
>
>The problem is, no one is addressing my question. Everyone has advice on how to change the backup process, which I don't own. I need to know about the possibility of data corruption when the plug is pulled on an open file that is idle.

Everyone's workstation and network environment is different. If you really want an accurate idea, you could test by opening some (scratch) table(s) and then deliberately disconnect your network cable. Do this a few times and you should have a pretty good idea.

I still think killing connections without a warning to interactive users is unacceptable. If the "owners" can't, or won't mend their ways, you could create a reminder .EXE in VFP on your local HD and schedule it to run every evening at 11:55 pm. If you're not there and your machine's not running, nothing happens.
Regards. Al

"Violence is the last refuge of the incompetent." -- Isaac Asimov
"Never let your sense of morals prevent you from doing what is right." -- Isaac Asimov

Neither a despot, nor a doormat, be

Every app wants to be a database app when it grows up
Previous
Reply
Map
View

Click here to load this message in the networking platform