Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Windows 2003 buffer flushing
Message
General information
Forum:
Visual FoxPro
Category:
Databases,Tables, Views, Indexing and SQL syntax
Title:
Windows 2003 buffer flushing
Environment versions
Visual FoxPro:
VFP 9 SP1
OS:
Windows XP SP2
Network:
Windows 2003 Server
Database:
Visual FoxPro
Miscellaneous
Thread ID:
01170405
Message ID:
01170405
Views:
53
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?
TIA
Beer is proof that God loves man, and wants him to be happy. - Benjamin Franklin
John J. Henn
Next
Reply
Map
View

Click here to load this message in the networking platform