Create Geo-Replication in Azure SQL Database

Introduction

Geo-replication is one of the very useful features in the Azure databases. It can protect & backup our data from failures in the database. In a real-world scenario, companies store a large amount of user data in a cloud database and it runs in our nearest region. Unfortunately, some disaster caused in the data center at that time can cause our database to fail during business time. This problem can be solved by using the Geo-replication feature in the database.

Geo-replication is used to create a secondary database for the primary database in another region. If the primary database fails, Azure can automatically switch to a secondary database. Now our business runs without any interruptions.

By reading this article, you will learn about how to configure a Geo-replication in Azure SQL database.

Read my previous articles in Azure SQL,

Prerequisites

Azure cloud account
Edge (or) Other browsers
Stable Internet Connection
Minimum knowledge in Database
Azure SQL server & database

Step 1

Step 2

Go to your database Dashboard and then select the “Geo-Replication” option in the settings section from the left pane. In this page, the Primary database is displayed as a blue-colored mark on the map, and the green color marks an available zone for creating a secondary database for replication.

Create A Geo-Replication In Azure SQL Database

Step 3

Scroll down and select the nearest zone from the target list. My primary database runs in “South India”. Now I am selecting a replication region as “West India”.

Step 4

After selecting the target region, it automatically opens the “create secondary page”. On this page, click the “Target Server” option and then click “Create a new server”.

On the right side, the “Create new server” pane has opened. After filling all credentials to your target server, click the “Select” button.

Step 5

Your target server is selected. Afterward, click on the “Ok” button to deploy it to the target server.

Step 6

Now you can wait 2 minutes to deploy and seed our data from your primary database.

It displays an initializing status in the secondaries list from the bottom of the map.

Step 7

After initializing, it starts the seedling stage. In this stage, copy the data from the primary server to the target server.

Step 8

After Seeding, our target server is ready in “Readable” status. At the top of the map, the page displays that both database servers are connected.

Step 9

Go to the Azure Dashboard and select “All resources”.

Step 10

In the “All resource” page, our target server is listed on this page. Then, click the” Target server name”.

Summary

Finally, we have successfully created Geo-replication for Azure databases.