Daily snapshots and retention
How automatic daily backups work, how to set retention, time and snapshot count, and when they cost money.
Every database gets automatic daily backups, stored offsite. Manage them on Databases > Backups (Backups & Migration Vault).
What is free
Daily backups are on at no cost up to the free allowance, which the page states. Going beyond it, or turning on hourly backups, is billed by database size. A Backup Vault Pricing Model dialog on the page shows the formula. A payment card is required once settings become billable. See Usage and the free allowance.
Set the policy
- Open Backups > Automated Daily Backup & Retention Vault. The badge shows ACTIVE with the retention.
- Choose a Retention Window (7 days up to a year, Forever, or Custom Duration...).
- Choose Max Backups Stored (1, 2, 5, 10, 50, 100, keep all, or custom).
- Set the Scheduled Backup Time and the timezone it uses.
- Choose Save Policy.
The page previews the monthly cost using your database size.
Take a snapshot now
Choose Create Instant Backup or Run Snapshot Now. Do this before risky changes such as an upgrade, import or bulk delete.
Saved snapshots and history
Saved Backup Snapshots Vault lists each file with size and date, with Download and Restore to DB.... Backup & Restore History records every backup and restore with status.
Turn automatic backups off
Under Advanced: disable automated backups, untick the keep-enabled option. Then on-demand exports expire and are purged after 1 hour. Think twice.
Good to know
- Offsite copies are encrypted before upload where the page says so.
- Older snapshots beyond your retention or count are removed automatically.
- A snapshot is of one database. For a whole project see Project recovery points.
- To restore, see Restore, download and import backups.
More guides in Console: backups & recovery
Restore, download and import backups
Restore a snapshot or uploaded dump into a database, download .sql.gz exports and use command-line dumps.
Project recovery points
Restore a whole project, all databases and stored files together, to an earlier point, and what happens to current data.
Hourly backups and point-in-time recovery
What the paid hourly backup option gives you, and what is and is not available for restoring to an exact moment.