What is sms.db in an iPhone backup?
sms.db is the database in which an iPhone stores its text messages, and it is included in the phone's backups. When you make a backup and open it in TextExhibit, the app reads messages from this database.
What it means in plain words
It holds iMessages and SMS, with their times, senders, and links to attachments. In a backup the file is stored under a scrambled name, so you cannot just look for it by hand.
Apps and forensic tools know how to find it.
How it applies to text messages
The backup version is a snapshot. Messages deleted before the backup was made are not in it, though database leftovers are a subject for forensic examiners.
Do not edit the file.
An example
A lawyer is told native means sms.db. Both sides agree instead on a PDF with a CSV, because the raw database is hard to read and includes other messages.
Why you can ignore this file name in practice
You do not need to find sms.db yourself. If you open a backup in TextExhibit, the app locates it. The name matters mainly when a lawyer or an examiner talks about source files, or when someone asks for native production.
If you are ever asked to hand over the database itself, understand what you are giving up: it contains all your messages, not only the conversation at issue. Discuss with counsel.
What a lawyer might mean
If a lawyer or an examiner mentions sms.db, they usually mean the raw source of your messages. Ask them whether they actually need the database or a readable export of one conversation. In most cases a PDF with a CSV, plus the original attachments, is what the other side wants to see.
What to keep in mind
- The raw database is not a readable record.
- It is part of a backup that holds much more.
- This is general information, not legal advice.
Questions
Can I open it myself?
With special tools. It is not needed.
Does it hold deleted messages?
Not normally.
Is it the same as chat.db?
It is the iPhone's version.
Export the whole conversation
TextExhibit turns a conversation into one PDF with exact times, names and numbers, photos in place and page numbers, on your Mac. Free to preview; $24.99 once to export.