Active geo-replication available on all Azure SQL Database service tiers
Published date: 29 April, 2016
Effective immediately, we’ve expanded our geo-replication features by enabling Active geo-replication across Azure SQL Database Basic and Standard service tiers. As a result, Standard geo-replication will be retired in April 2017. By using Active geo-replication in either a Basic database or a Standard database, customers receive numerous benefits that deliver greater security and business continuity in disaster situations:
- Database-level disaster recovery goes quickly when you’ve replicated transactions to databases on different SQL Database servers in the same or different regions.
- Cross-region redundancy allows applications to recover from permanent loss of a data centre caused by natural disasters, catastrophic human errors or malicious acts.
- Online secondary databases are readable, and they can be used as load balancers for read-only workloads such as reporting.
- With automatic asynchronous replication, after an online secondary database has been seeded, updates to the primary database are automatically copied to the secondary database.
For more information about Active geo-replication and its full set of capabilities, please visit the Active geo-replication for Azure SQL Database documentation page. For more information about pricing, please visit the SQL Database pricing page.