(SQL) Tip of the Day: Several Improvements to SQL Azure Geo-replication

  • Article

Today’s Tip…

Geo-replication has gotten some love recently. We have added the ability to manage geo-replication via T-SQL instead of just the portal and PowerShell. We added a failover/failback concept which will allow for DR drills without completely breaking down your replication. We also now allow for the secondary database to be a lower service object tier.

You can read all about the changes here: https://azure.microsoft.com/en-us/blog/spotlight-on-new-capabilities-of-azure-sql-database-geo-replication/