Understanding SQL database availability
Even when your databases are hosted in Azure, there is still a chance that failures and outages will occur. In the case of an outage (such as a total regional failure, which a natural disaster could cause, an act of terrorism, war, a government action, or a network or device failure external to the data centers of Microsoft), your data still needs to be accessible.
In Chapter 12, Creating Scalable and Secure Databases, we looked at database service tiers chosen when creating a SQL Server database – the General tier, Hyperscale tier, and Business Critical tier.
With the General and Hyperscale tiers, by default, data is replicated within a single region. However, it Is not regionally redundant. This is partly due to how data is protected within them. Essentially, data is stored in Azure storage accounts and therefore uses that underlying technology to spread and replicate data among physical disks. However, there is still only ever one...