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.
 
  • Azure cloud account
  • Edge (or) Other browsers
  • Stable Internet Connection
  • Minimum knowledge in Database
  • Azure SQL server & database
Step 1
 
Log in to the Azure portal.
 
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”.
 
Create A Geo-Replication In Azure SQL Database
 
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.
 
Create A Geo-Replication In Azure SQL Database
 
Step 5
 
Your target server is selected. Afterward, click on the “Ok” button to deploy it to the target server.
 
Create A Geo-Replication In Azure SQL Database
 
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.
 
Create A Geo-Replication In Azure SQL Database
 
Step 7
 
After initializing, it starts the seedling stage. In this stage, copy the data from the primary server to the target server.
 
Create A Geo-Replication In Azure SQL Database
 
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.
 
Create A Geo-Replication In Azure SQL Database
 
Step 9
 
Go to the Azure Dashboard and select “All resources”.
 
Create A Geo-Replication In Azure SQL Database
 
Step 10
 
In the “All resource” page, our target server is listed on this page. Then, click the” Target server name”.
 
Create A Geo-Replication In Azure SQL Database
 

Summary

 
Finally, we have successfully created Geo-replication for Azure databases.
 
Create A Geo-Replication In Azure SQL Database