All resources
Strategy2026-07-18 · 6 min read

The 3-2-1 Backup Rule for Production Databases

Three copies, two media types, one off-site. How the classic rule maps onto MySQL, PostgreSQL, SQL Server and MongoDB workloads in 2026.

Why the rule still holds

The 3-2-1 rule predates the cloud, but the failure modes it protects against — hardware loss, silent corruption, and site-wide outages — have not gone anywhere. Managed database snapshots live in the same account, region, and blast radius as the database they protect.

Keeping three copies of every database, on two different storage types, with at least one copy off-site, means a single compromised credential or deleted project cannot take your recovery path with it.

Mapping it to your stack

Copy one is the live database. Copy two is a local or nearby snapshot for fast restores — the copy you reach for when someone drops a table at 4pm. Copy three is the encrypted off-site vault you control, written by an agent that only holds outbound credentials.

With SaveMyDB the agent runs inside your network, pushes encrypted backups to your own vault, and never requires you to open an inbound port.

Test the restore, not the backup

A backup job that reports success proves a file was written; it does not prove that file can rebuild your schema and data. Schedule a monthly restore into a scratch server and diff the row counts. One-click restore makes this a five-minute task rather than a project.

savemydb

Back up, monitor and restore every database for $1 each per month

Get Started Now