Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Safety of CDX'es and DBF's from crashing of power supply
Message
From
31/10/1997 17:18:36
 
 
To
31/10/1997 16:57:20
General information
Forum:
Visual FoxPro
Category:
Other
Miscellaneous
Thread ID:
00057602
Message ID:
00057680
Views:
29
>>Is there some tools to make sure that
>>your DBF, DBC or CDX files will remain correct
>>after power supply crashing?
>>Sometimes it's brokes and we get message: "index don't match database. recreate index".
>
>
>There is no totally reliable way. However, you can take some safety measures:
>
>1) Put the server on a battery backup.
>2) Compaq makes servers with dual power supplies. If one fails, the other takes over automatically.

Like the last person said, there is no way to do that unless you have a battery back up or database back up $$$$$, regenerating your indexes is one of the first tools you should create, I personally have a routine to do this automatically by searching all databases in the directory and generating the code for indexing within another prg, it's very helpfull if you don't have done it yet. If you want it send me a mail.

The real problem when a power failure comes is when you are appending a record because there are several things that get outdated in this process, specialy the database header. I have another program for repairing headers, same as the other, just ask for ot by mail.

Good luck
Mao
intelisoft Corporation
Previous
Reply
Map
View

Click here to load this message in the networking platform