(SQL) Tip of the Day: Information about how SQL Azure Backups Are Tested
Today’s Tip…
- Disaster drills occur quarterly – simulation of full region outage and verification of recovery procedures.
- Backups occur continuously on all databases. Automated monitoring of telemetry is in place to verify that backups have successfully completed.
- Restores occur continuously as initiated by customers. Automated monitoring of telemetry is in place to verify that restores successfully complete.
- Backup files are stored both in the same region and in another region in the same geography. (e.g. DB in JapanEast, backups are in JapanEast and JapanWest).