Use sqlite3 .backup, or checkpoint the WAL first, to get a restore point that holds every write.
Back Up SQLite With the Backup Command
Vault note, not reviewed against the source. Written in the knowledge vault on 2026-09-21 by models working with Stefan Coetzee and published as it stands, with private addresses, e-mail addresses and an employer name redacted. Check claims against the primary source before relying on them.
From the knowledge vault, SRE/incidents/Back Up SQLite With the Backup Command.md. Built from scripts/docs by build_docs.py.