Plateforme Level Extreme
Abonnement
Profil corporatif
Produits & Services
Support
Légal
English
Zero size DCX file?
Message
De
17/08/2004 02:51:48
 
 
À
15/08/2004 22:53:31
Jill Derickson
Software Specialties
Saipan, CNMI
Information générale
Forum:
Visual FoxPro
Catégorie:
Base de données, Tables, Vues, Index et syntaxe SQL
Divers
Thread ID:
00933461
Message ID:
00933752
Vues:
16
>Hi,
>
>I have a client whose DCX file is having trouble...and the symptom is that the size of the DCX file is zero. What could cause this?
>
>We can restore the proper DCX and all is well...until the next time.
>
>They have had some electrical problems (common here), but we thought they were fixed. I wanted to check here to see if anyone has seen this problem.
>
>Thanks for any input. j

Well, bad power can do this... ideally you'd want UPSs on server, workstations and switches.

If you can get exclusive use of the database, you can issue VALIDATE DATABASE RECOVER, which will rebuild the structural .DCX index file. You can do this even if the .DCX is deleted i.e.
ERASE MyDB.DCX
OPEN DATABASE MyDB EXCLUSIVE
VALIDATE DATABASE RECOVER
If the database container never changes, one trick you could try would be to mark the .DBC/.DCT/.DCX files as read-only.
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
Précédent
Suivant
Répondre
Fil
Voir

Click here to load this message in the networking platform