> How would that happen in practice with SQLite? perhaps this? It would happen as with any other file. The 3-2-1 rule don't care about file contents. You're r

> How would that happen in practice with SQLite? perhaps this? It would happen as with any other file. The 3-2-1 rule don't care about file contents. You're right about your number 1. A backup storage close to the source is in important for backup speed and fast recovery. The different storage device/media comes from the era when the primary medium was tape. Not so important any longer, if you ask me personally. The S3 would qualify as remote location, but ONLY if it's stored as immutable. And no fake immutability that can be overwritten. True immutability that you cannot delete with admin privileges. The reason is that remote should be air-gapped so an attacker truly can't mess with the backups. The mounted network share is useless. Don't do that.