Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

 All Forums
 General SQL Server Forums
 Data Corruption Issues
 DBF corrupted database

Author  Topic 

edward24dalton
Starting Member

1 Post

Posted - 2014-07-16 : 13:23:54
Hey friends, I'm in great trouble here.

I'm using Microsoft Visual FoxPro 9.0 on my Windows 7 machine. I had some DBF files which was created in MS Visual FoxPro. The files were undoubtedly valuable since they contained my crucial data related to my office work. The files are now invalid therefore, inaccessible. I can't access any of my database files. Whenever I try to open one of them this comes in front of me: "File filename.dbf does not exist".
According to me this must be a file corruption error states the file is corrupted. I don't know how did it get corrupted. I'm dying to get these files back. Please help in this.

Thanks in advance.

tkizer
Almighty SQL Goddess

38200 Posts

Posted - 2014-07-16 : 14:10:58
Unfortunately you are unlikely to receive help here as SQLTeam.com is for Microsoft SQL Server. I am not sure that there is anyone here that uses or has used FoxPro or is experienced enough to help you. You could try posting your question on a site that specializes in FoxPro, though admittedly there might not be one.

Tara Kizer
SQL Server MVP since 2007
http://weblogs.sqlteam.com/tarad/
Go to Top of Page

jason36moks
Starting Member

1 Post

Posted - 2014-07-16 : 18:24:13
It is not necessary to rebuild a corrupt database. All corrupt databases can fixed in less than one minute.

The solution is: Open database to main screen

Copy the database but only one record(just pick a not recent record number at random; include "all", I usually name this database "FixMMDD" (( month Day))

Open original database to mainscreen and append the FIXMMDD.dbf.

You're done.

Occassionally you may have to update indexes. Very rarely are any records lost and when it happens those few records are clearly garbled.

I've been doing this for three years with no problems.

If you have fields that increment you'll have to adjust that for your last valid value.

OTHERWISE

I think those files of your which seem unreadable are corrupt. Just one thing always keep in your mind that corruption can make a file unreadable or useless. And due to this file becomes inaccessible. Any corrupt or damaged file can't be accessed until it gets fully repaired. All you need just remove the error from your DBF files and after doing this you can access those corrupt files. The data inside those files will be readable right after you repair them. You just need to consider about a software program or shall I suggest you about a tool which I have used?

Check this one: DBF Repair Kit

It will help you as it helped me. Just try its demo version http://www.dbf.repair/ to see the preview of the content of the files which are unreadable.
Go to Top of Page
   

- Advertisement -