So I've run across a problem where my wife's texts all got randomly deleted from her phone. It happens, I know, however the problem here is that she had around 300 text messages or so locked in her phone that were going to be used in a custody battle for her son to show that her son's deadbeat father does not deserve to have custody of her son. Long story short, we lost all of these texts and the father is cleaning up his act, his hoarder-style household, and putting on his best brady bunch dad impression for the courts. Without evidence we can't do much here and forensics experts cost $1,200 or more for a 50/50 chance that the data is still on the phone. We have since replaced the wife's phone, so I am able to do with it what I want to attempt recovery of this data.
So this is where I need some help. My wife has a Samsung Fascinate with Gingerbread (2.3.5). I will be following the root guide in the forum here in order to get unlock access to /data/data/com.android.providers.telephony/databases/mmssms.db, which is where the SMS database is supposedly stored. I will be obtaining a SQLite database viewer, but here is my question if anyone can help me out...
Does this database hold deleted data still? If so, will I see all of this data within the tables or are there database queries that can help me to look for unreferenced rows/rows pending deletion? Also, if anyone has any suggestions I am definitely open to them.
Just as a side note - I have already tried contacting Verizon to subpoena the texts to be recovered. Verizon has a 10 day limit on recovering texts that were deleted. Unfortunately, this is 10 days since the text was received...so all the locked texts from her phone that were received months ago are outside of this window. Either way, any help is appreciated.