Active Geo-replication open to all
On 29th April 2016 Microsoft announced Active Geo-replication available on all Azure SQL Database service tiers.
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 datacenter 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.
Thanks,
Sarabpreet Singh Anand
Subscribe now to get latest Tips\blog posts in your Inbox
Follow @SQLChamp
Follow @Sarab_SQLGeek