SQL Server Forums
Profile | Register | Active Topics | Members | Search | Forum FAQ
 
Register Now and get your question answered!
Username:
Password:
Save Password
Forgot your Password?

 All Forums
 General SQL Server Forums
 Data Corruption Issues
 DBF corrupted database
 New Topic  Reply to Topic
 Printer Friendly
Author Previous Topic Topic Next Topic  

edward24dalton
Starting Member

1 Posts

Posted - 07/16/2014 :  13:23:54  Show Profile  Reply with Quote
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

USA
37129 Posts

Posted - 07/16/2014 :  14:10:58  Show Profile  Visit tkizer's Homepage  Reply with Quote
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 Posts

Posted - 07/16/2014 :  18:24:13  Show Profile  Reply with Quote
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
  Previous Topic Topic Next Topic  
 New Topic  Reply to Topic
 Printer Friendly
Jump To:
SQL Server Forums © 2000-2009 SQLTeam Publishing, LLC Go To Top Of Page
This page was generated in 0.06 seconds. Powered By: Snitz Forums 2000