Backup files · Notes

ca3bc056d4da0bbf88b5fb3be254f3b7147e639cis notes.sqlite

In an iPhone backup, the file ca3bc056d4da0bbf88b5fb3be254f3b7147e639c is notes.sqlite. The Notes database from iOS 8 and earlier. Newer phones still have the file, but keep notes in NoteStore.sqlite.

Real namenotes.sqlite
DomainHomeDomain
PathLibrary/Notes/notes.sqlite
In the backup folderca/ca3bc056d4da0bbf88b5fb3be254f3b7147e639c
Its name is the SHA-1 ofHomeDomain-Library/Notes/notes.sqlite
AppNotes
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 Notes screen. Guide: Export notes from an iPhone backup

What it holds

Before iOS 9, the Notes app kept notes here. Each note is a row in ZNOTE, and its text is HTML in ZNOTEBODY.ZCONTENT.

iOS 9 moved notes to NoteStore.sqlite, but the old file stayed: every backup we checked, up to iOS 17.3, still has it.

Key columns

Tables by iOS version

The same 14 tables in every backup we opened (iOS 13.3.1, 13.4.1, 15.3.1, 16.1.2 and 17.3):

ACHANGE, ATRANSACTION, ATRANSACTIONSTRING, ZACCOUNT, ZNEXTID, ZNOTE, ZNOTEATTACHMENT, ZNOTEBODY, ZNOTECHANGE, ZPROPERTY, ZSTORE, Z_METADATA, Z_MODELCACHE, Z_PRIMARYKEY

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 Notes. OpenExtract looks here first and shows these notes if there are any; otherwise it reads NoteStore.sqlite. Step by step: Export notes from an iPhone backup.

By hand. In a backup that isn't encrypted, ca/ca3bc056d4da0bbf88b5fb3be254f3b7147e639c 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 →