Azure SQL Database allows you to easily deploy up to four read-only replicas of your database in different regions. Completed transactions are asynchronously replicated to read-only replicas. The secondary databases are available for querying at all times and can be failed over to in case of a disaster. Active geo-replication provides an RPO of under five seconds (which is an amazing RPO for a data store).
To configure geo-replication of SQL Database, execute the following steps:
- Navigate to Azure Portal -> SQL Databases -> <Database Name> -> Geo-Replication.
- Choose a target region (an Azure paired region will be recommended) as shown in the following screenshot:
- Configure the target server (similar to the new SQL server ...