(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).