Backups and recovery points

Two layers of protection

Database snapshots protect one database. Project recovery points protect the whole project: every database plus stored files, taken together.

Snapshots

On Databases > Backups, daily backups are on by default. The page states the free allowance; beyond that, or with hourly backups, billing is by database size and needs a card.

1. Under Automated Daily Backup & Retention Vault, pick a Retention Window and Max Backups Stored.
2. Set the Scheduled Backup Time and timezone.
3. Choose Save Policy.

Take a manual one with Create Instant Backup before risky changes.

Restore a snapshot

Restore to DB... then Proceed with Restore runs the snapshot into the database. There is no automatic safety copy, so back up first. Needs Owner, Admin or Developer.

Recovery points

The Project recovery points card appears when the platform has them on. Types: Scheduled, Manual, Before a restore. Owners choose Restore, tick Databases, Stored files and optionally Sign-in users, API keys and secrets, type the project name and confirm. The current state is saved first, and newer files are kept aside for a limited time.

Practice

Run a restore drill on a scratch project every quarter. A backup you never restored is a hope.

Recap

• Snapshots per database; recovery points per project.
• Always snapshot before you restore.