How to recover damaged database file ?

188 views
Skip to first unread message

Rudolph Davis

unread,
Dec 11, 2015, 6:42:41 PM12/11/15
to Session Buddy Discussion
I'm using Chrome with Session Buddy plugin, and somehow it's database file was written over with chrome cache file, but I managed to restore it partly using Recuva. Renamed it and launched Chrome, but Session Buddy showed page which said that there's something wrong with the plugin. So I guess it's corrupted and Session Buddy can't read it properly..

Are there any possible ways to repair SQlite database file ?


Rudolph Davis

unread,
Dec 11, 2015, 6:54:16 PM12/11/15
to Session Buddy Discussion
wow.. thank god I had shadow copy up and running all the time. I managed to get back shadow copy of that DB file from December 9th, using ShadowExplorer... But this was impossible to restore it using Recuva (it doesn't search file's previous shadow copies).

Now I tried to replace it with current DB file, but strangely it doesn't work.. how it's possible if on Dec. 9th it worked OK - that's the date from which I recovered the DB file..

Rudolph Davis

unread,
Dec 11, 2015, 7:02:05 PM12/11/15
to Session Buddy Discussion
This is from console

  1. exception: DOMException: Failed to execute 'openDatabase' on 'Window': unable to open database, failed to start transaction (26 file is encrypted or is not a database) at Error (native) at new extractSessionTransactions (chrome-extension://edacconmaakjimmfgnblocblbcdcpbko/js/db.js:4:15) at new popSession (chrome-extension://edacconmaakjimmfgnblocblbcdcpbko/js/db.js:37:18) at chrome-extension://edacconmaakjimmfgnblocblbcdcpbko/js/background.js:680:34 at chrome-extension://edacconmaakjimmfgnblocblbcdcpbko/js/background.js:701:3
    1. code: 11
    2. message: "Failed to execute 'openDatabase' on 'Window': unable to open database, failed to start transaction (26 file is encrypted or is not a database)"
    3. name: "InvalidStateError"
    4. stack: "Error: Failed to execute 'openDatabase' on 'Window': unable to open database, failed to start transaction (26 file is encrypted or is not a database)↵    at Error (native)↵    at new extractSessionTransactions (chrome-extension://edacconmaakjimmfgnblocblbcdcpbko/js/db.js:4:15)↵    at new popSession (chrome-extension://edacconmaakjimmfgnblocblbcdcpbko/js/db.js:37:18)↵    at chrome-extension://edacconmaakjimmfgnblocblbcdcpbko/js/background.js:680:34↵    at chrome-extension://edacconmaakjimmfgnblocblbcdcpbko/js/background.js:701:3"
    5. __proto__: DOMException
  2. source: "103948101"
  3. trace: "Error↵    at chrome-extension://edacconmaakjimmfgnblocblbcdcpbko/js/background.js:699:16↵    at chrome-extension://edacconmaakjimmfgnblocblbcdcpbko/js/background.js:701:3"
  4. __proto__: Object



On Saturday, December 12, 2015 at 1:42:41 AM UTC+2, Rudolph Davis wrote:

Rudolph Davis

unread,
Dec 12, 2015, 9:25:49 AM12/12/15
to Session Buddy Discussion

It's strange that none of the 4 versions of that file worked...

It was working on 9th and before that, it got corrupted yesterday, that's December 11th...




On Saturday, December 12, 2015 at 1:42:41 AM UTC+2, Rudolph Davis wrote:
Message has been deleted

Rudolph Davis

unread,
Dec 12, 2015, 10:02:14 AM12/12/15
to Session Buddy Discussion

I can't edit any posts, so I have to post a new one...

So I just found out that all those DB files - 4 versions doesn't have "SQLite format 3 @  " at the beginning if you open it with N++

But the new one that is created by sessionbuddy has it.. other 4 versions have just NUL NUL NUL NUL NUL NUL NUL  or random characters




Hans Meyer

unread,
Dec 12, 2015, 2:26:40 PM12/12/15
to sessionbud...@googlegroups.com
Send me the restored DB files. I'll take a look.

Hans

--
You received this message because you are subscribed to the Google Groups "Session Buddy Discussion" group.
To unsubscribe from this group and stop receiving emails from it, send an email to sessionbuddy-dis...@googlegroups.com.
For more options, visit https://groups.google.com/d/optout.

Rudolph Davis

unread,
Dec 13, 2015, 10:40:16 AM12/13/15
to Session Buddy Discussion
I can't, it contains confidential url's etc.. But can you recommend anything to fix this ? 

I have checked like 15 copies from various shadow copies, and every one has different first lines (in picture), the most oldest copy shows 'SQLite format' line, but others don't. And this oldest copy contains URL's. I've tried to recover it using SQLiteDoctor but it was unsuccessful. I guess Windows Shadow Copy compresses those files and they come out damaged and corrupted after restoring.



At first I used Recuva to recover the file when I realized it was missing, and it's status was Overwritten.
But then I found the same file in 4 shadow copies. At that time everything was OK, I restored them and none of them worked with Chrome. 



On Saturday, December 12, 2015 at 9:26:40 PM UTC+2, Hansifer wrote:
Send me the restored DB files. I'll take a look.

Hans
On Sat, Dec 12, 2015 at 8:02 AM, Rudolph Davis <rudi...@gmail.com> wrote:

I can't edit any posts, so I have to post a new one...

So I just found out that all those DB files - 4 versions doesn't have "SQLite format 3 @  " at the beginning if you open it with N++

But the new one that is created by sessionbuddy has it.. other 4 versions have just NUL NUL NUL NUL NUL NUL NUL  or random characters




--
You received this message because you are subscribed to the Google Groups "Session Buddy Discussion" group.
To unsubscribe from this group and stop receiving emails from it, send an email to sessionbuddy-discuss+unsub...@googlegroups.com.

Rudolph Davis

unread,
Dec 13, 2015, 10:48:33 AM12/13/15
to Session Buddy Discussion
Just found that oldest file using Recuva, it's showing everything is OK, NOT Deleted and No overwritten clusters... How is it possible for it to not work ? Everywhere I use that file it's showing damaged or corrupted. But at that time I was using Chrome and Session Buddy extension, they all were 100% working.

Hans Meyer

unread,
Dec 13, 2015, 2:41:28 PM12/13/15
to sessionbud...@googlegroups.com
I'm not familiar with Recuva or the process you're using to restore shadow copies, so I can't assist you with that.

Once you have a recovered SB user data file, though, make sure you refer to the "Advanced Restore" section of the following instructions to restore it into SB:

How to Back Up and Restore Session Buddy Data (Advanced Procedure)

Also, try opening the recovered file(s) with something like DB Browser for SQLite before trying to restore into SB to see if they're valid SQLite.

Hans


On Sun, Dec 13, 2015 at 8:48 AM, Rudolph Davis <rudi...@gmail.com> wrote:
Just found that oldest file using Recuva, it's showing everything is OK, NOT Deleted and No overwritten clusters... How is it possible for it to not work ? Everywhere I use that file it's showing damaged or corrupted. But at that time I was using Chrome and Session Buddy extension, they all were 100% working.

--
You received this message because you are subscribed to the Google Groups "Session Buddy Discussion" group.
To unsubscribe from this group and stop receiving emails from it, send an email to sessionbuddy-dis...@googlegroups.com.

Rudolph Davis

unread,
Dec 13, 2015, 2:48:05 PM12/13/15
to Session Buddy Discussion
I have tried many SQLlite viewers before posting here, but none of them successfully opened the DB. "Invalid file format" was the most common error.

And when I used SQLiteDoctor, it showed: 

---------------------------
SQLiteDoctor
---------------------------
Database is severely corrupted and SQLiteDoctor is not able to retrieve tables.
This is probably due to a failed write operation that resulted in a database header corruption. There is no way to recover this problem and application must Quit.
---------------------------
OK   
---------------------------

This is showing when I open DB file from Nov. 25 - at that time everything was OK. So it should have opened without any problems, but now I'm starting to think that the problem is Shadow copy.  Soon I'm gonna do System Restore to see if it helps..
To unsubscribe from this group and stop receiving emails from it, send an email to sessionbuddy-discuss+unsub...@googlegroups.com.

Hans Meyer

unread,
Dec 13, 2015, 9:32:31 PM12/13/15
to sessionbud...@googlegroups.com
OK. 

If you end up doing a System Restore, be aware that you may need to reinstall SB afterwards because it can be quirky about deleting Chrome extension code files.

Hans

To unsubscribe from this group and stop receiving emails from it, send an email to sessionbuddy-dis...@googlegroups.com.

For more options, visit https://groups.google.com/d/optout.

--
You received this message because you are subscribed to the Google Groups "Session Buddy Discussion" group.
To unsubscribe from this group and stop receiving emails from it, send an email to sessionbuddy-dis...@googlegroups.com.

Rudolph Davis

unread,
Dec 18, 2015, 8:13:20 PM12/18/15
to Session Buddy Discussion
Did a restore, but it didn't restore appdata folders... Even though everywhere it says that WSR restores programs and their data & files..


On Saturday, December 12, 2015 at 1:42:41 AM UTC+2, Rudolph Davis wrote:
Reply all
Reply to author
Forward
0 new messages