Plateforme Level Extreme
Abonnement
Profil corporatif
Produits & Services
Support
Légal
English
Windows 2003 buffer flushing
Message
Information générale
Forum:
Visual FoxPro
Catégorie:
Base de données, Tables, Vues, Index et syntaxe SQL
Titre:
Windows 2003 buffer flushing
Versions des environnements
Visual FoxPro:
VFP 9 SP1
OS:
Windows XP SP2
Network:
Windows 2003 Server
Database:
Visual FoxPro
Divers
Thread ID:
01170405
Message ID:
01170405
Vues:
54
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
Suivant
Répondre
Fil
Voir

Click here to load this message in the networking platform