Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Windows 2003 buffer flushing
Message
 
To
17/11/2006 01:22:22
General information
Forum:
Visual FoxPro
Category:
Databases,Tables, Views, Indexing and SQL syntax
Environment versions
Visual FoxPro:
VFP 9 SP1
OS:
Windows XP SP2
Network:
Windows 2003 Server
Database:
Visual FoxPro
Miscellaneous
Thread ID:
01170405
Message ID:
01170661
Views:
7
>>One of my customers just had the dreaded power outage with the almost dead battery on the UPS. The UPS lasted less than 3 minutes, not enough time for the user to get to it and shut down.
>>
>>Almost every time this has happened over the past 15 years we have been able to recover almost all the data. This time a considerable amount of data, as in the entire day's work, was lost. Several tables showed no error at all but the data just was not at the bottom of the table. Not just FoxPro data were lost. Another app (on the same server) that uses a separate file for every order suffered the same fate. Almost all of the days work, about 15 orders, was missing.
>>
>>The customer was able to restore from the previous days backup but I would like to prevent this in the future if possible.
>>
>>I remember a short time back there was a discussion about settings on Windows servers that could cause the server to not flush the buffers to disk. Anyone have any knowledge in that area?
>
>In VFP9 the new FLUSH FORCE command may help in committing data to disk.
>
>The link in Nigel's reply lists various registry (server AND workstation) settings you can make for "maximum reliability".
>
>Depending on the type of disk subsytem the server employs, you may be able to disable write-behind caching at the device or driver level. Take a look at
>
>Start...Control Panel...System...Hardware tab...Device Manager
>
>Under Disk drives, choose the device, go into its Properties. The Policies tab has some settings for Write caching and Safe Removal.
>
>If the server is a Terminal Server, take a look at http://support.microsoft.com/kb/324446


Al,
I believe you found what I was looking for. I will have to have the company's tech check it out but I'm almost certain that is it.

Thanks.
Beer is proof that God loves man, and wants him to be happy. - Benjamin Franklin
John J. Henn
Previous
Reply
Map
View

Click here to load this message in the networking platform