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.
| 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 |
 |
|
|
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 ToolboxTool 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. |
|
|
|
|
|
|
|
|
Corrupt records in DBF file