Sign up for the ITPro Today newsletter
Stay on top of the IT universe with commentary, news analysis, how-to's, and tips delivered to your inbox daily.
Active-Geo Replication Support in Azure SQL Database
Microsoft's active-geo replication support for SQL Database is a great option for those who want to run mission-critical solutions in the cloud.
Blair Greenwood
April 29, 2014
1 Min Read
Image Credit: Microsoft
Q: What's the active-geo replication support in Azure SQL Database?
A: Microsoft's Active-Geo Replication support for SQL Database lets users create up to four readable, secondary databases in any Azure region. If you've got active-geo replication enabled, then all transactions are committed to the database in your primary region, where they are continuously replicated to databases in other regions.
Related: Service-Service Restore Support in Azure SQL Database
In other words, this support feature is great for users who want more disaster recovery control at the database level. The cross-region redundancy makes it possible to recover in the event of a disaster.
The caveat to this feature is that it is currently only supported for Premium Tier databases. If you're trying to run mission-critical solutions, then it might be worthwhile to invest in the Premium Tier databases. And if you're finding that you don't need this feature and you're already on the Premium Tier, then you can always scale back to Standard or Basic Tiers.
About the Author
You May Also Like
.png?width=700&auto=webp&quality=80&disable=upscale)