Hourly backups and point-in-time recovery

Hourly backups

Tick Hourly backups on Backups for hourly snapshots instead of daily. It is a paid add-on, billed by size, and needs a card. The badge reads HOURLY ACTIVE. If the payment basis disappears the option is suspended with a grace period, you are emailed, then it is switched off; nothing is deleted at once.

Point-in-time recovery

There is no "restore to this minute" button in the Console, and shared databases do not offer self-service point-in-time recovery. Plan your recovery objective with what exists:

Need	Use
Lose at most a day	Daily snapshots
Lose at most an hour	Hourly backups
Undo a bad deploy across everything	Project recovery point
Exact-minute recovery	Dedicated deployment through support

Choose a recovery objective

Write down how much data you can lose (recovery point) and how long you can be down (recovery time). A restore of a large dump takes time; test it.

Practice

On a scratch database, take an Instant Backup, delete a table, restore, and time it.

Recap

• Know exactly what the Console can and cannot restore.
• Match backups to your tolerance for loss.