SQLite Backup-Restore Backup and Migrate is great as a backup system and thus allows some sort of versioning. This enables  me to roll back easily when developing and testing small sites which I tend to develop in a live environment.Migrating a dev version to a live site is also quite easy this way.

Backup and Migrate does not work for SQLLite, however. I assume the best would be to put the site in maintenance mode, and copy the .ht.sqlite as a backup ... restoring should then be the same in reverse.

Am I on the right track?
I suggest the use of the Read only mode module, it places your site in the maintenance mode, but your visitors can still view the site without enter or change content.

Then make a copy of your database and get out of the maintenance mode.