[olavgg]

SQLite supports online backup https://www.sqlite.org/backup.html

You can also use Litestream to create snaphots.