Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Quickly repairing a database container
Message
General information
Forum:
Visual FoxPro
Category:
Databases,Tables, Views, Indexing and SQL syntax
Miscellaneous
Thread ID:
00176788
Message ID:
00176812
Views:
25
Thanks for the great advice.

>I have two approaches.
>
>1. IF the DBC is stable and not going to change I include it in the EXE. I've done this on two projects and they never had a problem.
>
>2. If (1) isn't appropriate I first try to overwrite the DBC with a good copy. I always keep "Before and After" ZIP files of the DBC/DCT/DCX files when making a DBC change. This would be in addition to your hospital-run backup. Finally I USE the DBC as a table, PACK it and then see if I can pick out any obvious problems visually.
>
>After that, it's pray that the SysAdmin did his/her job correctly. My last contract backs up regularly on tape - but has never been able to restore a single file. We did our own data backups to CDs weekly.
>
>HTH
>Barbara
>
>
>
>
>>What is recommended for quickly repairing a database container that has become corrupt? Granted, this has only happened to me twice in 4 years, it still is a mad panic.
>>
>>What I do if I can't validate a database or seem to repair it:
>>
>>1) Free all tables
>>2) Delete database container
>>3) Create a new database container
>>4) Add tables back into database
>>5) Recreate views (done visually)
>>6) Add in stored procedures
>>7) Lengthen any long field names that have been shortened.
>>
>>Is there a faster way to do this? Can take 30 minutes to an hour to do all of this. Restoring the database container from a tape backup might take 2 to 3 hours since backups are done centrally at the hospital. By the time the Help Desk calls and analyst and they find the tape...
>>
>>What does everyone else do to speed up the repair/recreate process?
Previous
Next
Reply
Map
View

Click here to load this message in the networking platform