All times are UTC - 5 hours [ DST ]




Post new topic Reply to topic  [ 9 posts ] 
Author Message
 Post subject: SQL3 File Repair
PostPosted: June 11th, 2021, 8:21 
Offline

Joined: May 9th, 2017, 11:33
Posts: 140
Hi guys,

I have a recovery case. Customer is interested in a database file which is a backup of a software data.

I recovered the file, all sectors read ok. I tried to open file with different software online and offline but all say that "database disk image is malformed". So file is corrupt.

Any of you have knowledge about how can i repair the file so the customer can use it to import data back into his software?

If you had this case before and had success with any commercial tool let me know.

Thank you.


Top
 Profile  
 
 Post subject: Re: SQL3 File Repair
PostPosted: June 12th, 2021, 3:37 
Offline
User avatar

Joined: May 13th, 2010, 11:17
Posts: 2785
Location: Kuwait
can you post the file header here? and how big is the file?

_________________
Kuwait Data Recovery - UNIX GTC
The only reason for time is so that everything doesn't happen at once. By: Albert Einstein


Top
 Profile  
 
 Post subject: Re: SQL3 File Repair
PostPosted: June 14th, 2021, 5:16 
Offline

Joined: May 9th, 2017, 11:33
Posts: 140
Here it is:


Attachments:
Untitled.png
Untitled.png [ 31.42 KiB | Viewed 24600 times ]
Top
 Profile  
 
 Post subject: Re: SQL3 File Repair
PostPosted: June 15th, 2021, 5:07 
Offline

Joined: May 9th, 2017, 11:33
Posts: 140
I tried with command lines:

sqlite3 broken.db ".dump" | sqlite3 new.db - gives error

sqlite3 broken.db ".recover" | sqlite3 new.db - works without error but generated file is not recognized by the application.


Top
 Profile  
 
 Post subject: Re: SQL3 File Repair
PostPosted: June 15th, 2021, 6:03 
Offline
User avatar

Joined: May 13th, 2010, 11:17
Posts: 2785
Location: Kuwait
SQL lite header looks OK, most probably can be fixed ,,, some of the contents (records) will be lost
process is manually performed..

most probably due to bad sectors..

How big is the Original DB file? and the backup file you recovered?

_________________
Kuwait Data Recovery - UNIX GTC
The only reason for time is so that everything doesn't happen at once. By: Albert Einstein


Top
 Profile  
 
 Post subject: Re: SQL3 File Repair
PostPosted: June 15th, 2021, 8:22 
Offline

Joined: May 9th, 2017, 11:33
Posts: 140
Broken file has 6,41 MB (6.726.656 bytes)
Recovered file has 6,64 MB (6.971.392 bytes)

The problem was solved after all. Recovered file looks ok. I don't know however, how can i check what records are missing.

Initially data could not import because an additional configuration file was necessary next to the db.


Top
 Profile  
 
 Post subject: Re: SQL3 File Repair
PostPosted: June 15th, 2021, 9:20 
Offline
User avatar

Joined: May 13th, 2010, 11:17
Posts: 2785
Location: Kuwait
In my opinion here (depends on the bads location) the Diff. in size "Makes a big Diff" <<---- Not little to ignore
just image how much data (records) you can have in 200k, some DBs are compressed some are not (depends on the designer and how Pro. is the programmer)

after all, we can go through the guesses and continue list possibilities

To cut it short (if you are interested) such a repair case for us here costs 300-500$ (will quote after looking @the DB file with some more info. required about the App. used)

PM if this works with you here

and all the best

_________________
Kuwait Data Recovery - UNIX GTC
The only reason for time is so that everything doesn't happen at once. By: Albert Einstein


Top
 Profile  
 
 Post subject: Re: SQL3 File Repair
PostPosted: June 15th, 2021, 10:40 
Offline

Joined: May 9th, 2017, 11:33
Posts: 140
Recovered file has bigger size because there are some 00 00 inserts in a few places.

Also there are some changes in the header also.

Attachment:
Untitled.png
Untitled.png [ 11.47 KiB | Viewed 24481 times ]


Original recovered file from the customer drive had no bad sector at the time of reading it. I can guess there was a bad sector in the past that got relocated, but original data was not read totally right, or maybe some other kind of corruption.

Thank you for the quote einstein9. In case needed I know who can help.


Top
 Profile  
 
 Post subject: Re: SQL3 File Repair
PostPosted: June 17th, 2021, 3:58 
Offline
User avatar

Joined: May 13th, 2010, 11:17
Posts: 2785
Location: Kuwait
All the best :>

_________________
Kuwait Data Recovery - UNIX GTC
The only reason for time is so that everything doesn't happen at once. By: Albert Einstein


Top
 Profile  
 
Display posts from previous:  Sort by  
Post new topic Reply to topic  [ 9 posts ] 

All times are UTC - 5 hours [ DST ]


Who is online

Users browsing this forum: No registered users and 15 guests


You cannot post new topics in this forum
You cannot reply to topics in this forum
You cannot edit your posts in this forum
You cannot delete your posts in this forum
You cannot post attachments in this forum

Search for:
Jump to:  
Powered by phpBB © 2000, 2002, 2005, 2007 phpBB Group