Backups and restore
Managed databases are backed up automatically. Set the schedule and retention, back up on demand, verify or download a backup, and restore it into a new or the same database.
Every database on the server is backed up automatically. Open the database and select Backups.
Backup settings
Under Backup settings:
- Scheduled backups: Daily (included), Hourly (adds a percentage of the database price, shown on the page), or Off (back up manually only).
- Backup window (UTC): when the daily backup runs.
- Keep automatic backups for: 7 days is included in the plan. Longer retention uses extra backup storage, billed per GB per month on your invoice.
Select Save settings. Backups are encrypted and stored in the database's region.
Back up now
Select Back up now. If the server holds several databases, pick the ones to back up. Each database gets its own backup, and they appear in the list as they finish. Manual backups stay until you delete them.
Verify and download
On a completed backup:
- Verify backup checks that the backup can be restored, and shows Verified with the time.
- Download backup saves a copy, for example to keep it elsewhere.
Restore a backup
- Select Restore on the backup.
- Under Restore into, choose:
- A new database: the backup becomes a new database with the name you give it, same plan, region and engine, billed as a separate database. The current one isn't changed.
- This database: everything in it is replaced with the backup's contents. Changes made since the backup are lost, and connections may be interrupted while it restores.
- Confirm.
Restores and checks follows each restore and verification until it finishes, with its log. When a restore finishes, open the Data Explorer to check the data.
Related
Users and databases
Add database users with admin, read-write or read-only access, reset their passwords, and create more logical databases on the same managed database server.
Data Explorer and SQL console
Browse and edit tables in the browser, run SQL safely in read-only or write mode, import and export data, track schema changes and run one script on many databases.