Backup files · Calendar

2041457d5fe04d39d0ab481178355df6781e6858is Calendar.sqlitedb

In an iPhone backup, the file 2041457d5fe04d39d0ab481178355df6781e6858 is Calendar.sqlitedb. The Calendar database: events, their times and places, and the calendars they belong to.

Real nameCalendar.sqlitedb
DomainHomeDomain
PathLibrary/Calendar/Calendar.sqlitedb
In the backup folder20/2041457d5fe04d39d0ab481178355df6781e6858
Its name is the SHA-1 ofHomeDomain-Library/Calendar/Calendar.sqlitedb
AppCalendar
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 itNot yet.

What it holds

Calendar.sqlitedb holds the Calendar app's events. Each event is a row in CalendarItem, with its title in summary and its times in start_date and end_date. Calendar lists the calendars, and Location the places events are at.

Key columns

Tables by iOS version

iOS 13.3.1 has 37 tables:

Alarm, AlarmChanges, Attachment, AttachmentChanges, Calendar, CalendarChanges, CalendarItem, CalendarItemChanges, Category, CategoryLink, ClientCursor, ClientCursorConsumed, ClientSequence, Contact, ContactChanges, EventAction, EventActionChanges, ExceptionDate, ExceptionDateChanges, Identity, Location, Notification, NotificationChanges, OccurrenceCache, OccurrenceCacheDays, Participant, ParticipantChanges, Recurrence, RecurrenceChanges, ResourceChange, ScheduledTaskCache, Sharee, ShareeChanges, Store, StoreChanges, SuggestedEventInfo, _SqliteDatabaseProperties

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

OpenExtract doesn't read it yet. OpenExtract doesn't have a Calendar screen yet.

By hand. In a backup that isn't encrypted, 20/2041457d5fe04d39d0ab481178355df6781e6858 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. Tools such as iphone_backup_decrypt, the open-source library OpenExtract uses, can decrypt a single file; then open the decrypted copy with any SQLite browser, such as DB Browser for SQLite.

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 →