You now have your database up and running in the cloud, and you can even connect to it, and create, delete, and update the tables as you wish.
In this section, you will learn how to build a highly available and business continuity database.
Microsoft does its best to address any issues that may occur in Azure SQL Database, and it provides solutions to the following issues.
Hardware failure is something that is expected to happen, but it will not be the reason that you lose your databases.
Just as replication is provided for storage, there is a similar safeguard for Azure SQL Databases.
If hardware failure occurs, there are three copies of your database, separated across three physical nodes. The three copies consist of one primary replica and two secondary replicas, and, to avoid any data loss, write operations are not committed in the primary replica until they have been committed to one...