A managed database can back itself up so you can recover from a mistake or a failure. This is the most important thing to set up on any database that holds real data.
Take a backup
- Open your instance under Databases.
- Choose the backup action and give it a Name.
- Create it. You can take one on demand before a risky change.
Schedule automatic backups
In the instance's backup settings, turn on a schedule (for example daily) and set how many days of backups to keep. Automatic backups run quietly and expire on the schedule you set.
Restore
Restoring creates a new database instance from a backup rather than overwriting the current one. This is deliberate and safe:
- Choose a backup and restore it to a new instance.
- Check the restored copy has what you expect.
- Point your application at whichever instance you want to keep, then remove the other.
Backups use storage, so keep enough history to undo the mistakes you might realistically need to (a week or two is common) and let older ones expire. If your app cannot reach the restored instance, see Cannot connect to a managed database.