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
 Other Forums
 Other Topics
 Corrupt records in DBF file

Author  Topic 

liviopagani
Starting Member

1 Post

Posted - 2014-11-01 : 07:39:54
Hello all,

Suddenly, one of the dbf files lost 21 records, those 21 records were entered that day and if I check using the browse command I can see that there is no information (zero and blank spaces) but if I check the content of every character field I can see exchange characters.

This problem has happened twice, in both cases I was not able to recover the information from a backup, because it process runs at night and the problem happens with records entered few hours before.
Does somebody have an idea regarding to this trouble?

Thanks!

SwePeso
Patron Saint of Lost Yaks

30421 Posts

Posted - 2014-11-01 : 09:35:51
Faulty driver?



Microsoft SQL Server MVP, MCT, MCSE, MCSA, MCP, MCITP, MCTS, MCDBA
Go to Top of Page

lindenjohan
Starting Member

1 Post

Posted - 2014-11-01 : 16:33:13
Refer to:- http://www.filerepairforum.com/forum/databases/databases-aa/dbase-iv-clipper-foxpro/429-how-can-i-open-corrupted-dbf-file-via-ms-foxpro - here you may get or discuss answer to current problem, no pay, no difficult registration with input many private data.

As a variant see DBF Fix Toolbox

Tool is paid, but might be helpful, in case of serious .dbf corruption- http://www.dbf.fixtoolbox.com/

And at last, below the guide how to recover .dbf file, see steps...

1. Open the dBase command line from the Windows Start menu.

2. Log into the local dBase software with your username and password.

3. Click on the dBase command line section of the window that is open.

4. Type "dbf /recover yourDbaseFile.dbf" into the command line, where "yourDbaseFile.dbf" is the name of the dBase file whose tables are corrupted.

5. Press "Enter." dBase takes some time (ranging from a few minutes to a few hours, depending on the size of the database) to analyze and repair the file and its contents. You are alerted when this process is finished.
Go to Top of Page
   

- Advertisement -