Backup files · Messages

3d0d7e5fb2ce288813306e4d4636395e047a3d28is sms.db

In an iPhone backup, the file 3d0d7e5fb2ce288813306e4d4636395e047a3d28 is sms.db. The Messages database: every text and iMessage, who it was with, when, and which attachments go with it.

Real namesms.db
DomainHomeDomain
PathLibrary/SMS/sms.db
In the backup folder3d/3d0d7e5fb2ce288813306e4d4636395e047a3d28
Its name is the SHA-1 ofHomeDomain-Library/SMS/sms.db
AppMessages
Seen iniOS 13.3.1, 13.4.1, 15.3.1, 16.0, 16.1.2 and 17.3.
Needs an encrypted backupNo. Unencrypted backups have it too.
OpenExtract reads itYes, on the Messages screen. Guide: Export iPhone messages

What it holds

sms.db is where the Messages app keeps conversations: the text of each message, who it was with, when it was sent or received, whether it was read, and which attachments go with it. Group chats are in it too.

The attachments themselves aren't inside it. Photos, videos and voice messages sent in Messages are separate files in the backup, under Library/SMS/Attachments/ in MediaDomain, and the attachment table names each one.

FaceTime calls started from a Messages conversation also leave a row in sms.db, and OpenExtract's Calls screen adds those to the call history.

iOS 16 gave Messages a Recently Deleted folder, and sms.db gained tables for it: the iOS 16.1.2 and 17.3 backups have recoverable_message_part and chat_recoverable_message_join, which the older ones don't.

Key columns

Tables by iOS version

iOS 13.3.1 has 14 tables:

_SqliteDatabaseProperties, attachment, chat, chat_handle_join, chat_message_join, deleted_messages, handle, kvtable, message, message_attachment_join, message_processing_task, sync_deleted_attachments, sync_deleted_chats, sync_deleted_messages

Then, version by version:

The iOS 16.0 backup is encrypted with a password that isn't public, so only its list of files was checked, not its tables.

How to open it

Free, in OpenExtract. Open the backup in OpenExtract and choose Messages. People and Timeline use it too. OpenExtract shows every conversation with its photos and attachments, and saves them as PDF, HTML, CSV or text. It can also recover deleted messages that are still in the file. Step by step: Export iPhone messages.

By hand. In a backup that isn't encrypted, 3d/3d0d7e5fb2ce288813306e4d4636395e047a3d28 is an ordinary SQLite database with no extension. Copy it out of the backup folder and open the copy with any SQLite browser, such as DB Browser for SQLite. Work on a copy: changing anything inside a backup can stop it from restoring.

In an encrypted backup, the file in the backup folder is encrypted with a key of its own, which only the backup password unlocks, so nothing can open it until it's decrypted. OpenExtract does that when you open the backup and type its password.

Checked against public test backups from iOS 13.3.1, 13.4.1, 15.3.1, 16.1.2 and 17.3, and the file list of an iOS 16.0 backup, reading only file, table and column names. How we checked · All backup files

Read the backup, not the hashes.
OpenExtract opens iPhone backups for you. Free, open source, nothing uploaded. Mac · Windows · Linux.
Download OpenExtract →