Several weeks ago, I posted about losing precious voicemails from my mother after her passing, and how the Clockwork Mod backup saved them. After some further fiddling around with the backup, I picked up a few more interesting tricks for Windows users. Details after we get our groove on.

Interestingly enough, the voicemails have an associated database. The database is a standard SQL format, so you can use the Firefox SQL Explorer to open it up (if you don’t have a SQL browser already). You will probably have to add the extension .sql to the file.

Using the structure from the previous post, the database is located at C:androiddatacom.coremobility.app.vnotesfilesvnotes_db

The second little gem is in this backup you can view your SMS messages, as well. The SMS database contains the datestamp, sender, recipient, and the message body (among other things). Being a [bored] investigator, I spent some [probably too much] time exporting the database to MySQL so I could search the SMS via PHP. Turns out I really didn’t have anything worthwhile, but, if you do, here’s where the database in located in the extracted backup.

C:androiddatacom.android.providers.telephonydatabasesmmssms