August 2017
Intermediate to advanced
468 pages
12h 5m
English
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: