Unfortunately my HTC Desire SMS app crashed (HTC official android 2.2), all SMS and MMS were lost. When I tried to recover from a previously backed up SMS file (generated by Desire SMS app), but it didn't work, prompting failed to recover. But I found actually most of SMS and MMS had been recovered, with some important ones still missing. I want to open the backup file directly to read out the missed SMS, how to do it? Someone said the backup file is SQLite file, right?
All the messages in Android are stored in an SQlite database on the mobile. So, I guess this Desire backup application simply copies this database to an accessible folder (presumably sdcard).
Since it's an SQLite file, you can simply download and use an SQLite Browser and view the SMS in there.
Try the unix
strings command against the db file directly. This will search the binary db file for human readable strings and print them on the console.