Architecting Microsoft Azure Solutions - Exam Guide 70-535

Configuring active geo-replication and failover groups

In this example, we are going to set up active geo-replication and failover groups for a single database. Note that this can be done for an Elastic Pool, as well:

1. Navigate to the Azure Portal by opening https://portal.azure.com/.
2. First, create the SQL Database. Click on New and type SQL Database in the search bar.
3. On the next screen, add the following settings in the creation blade and click on Create, as shown in the following screenshot:

Create SQL Database

4. Click on Create a new server, add the following settings, and click on Select:

Create SQL Server

5. Click the pricing tier; ...