Thursday, October 27, 2016

Azure - Business Continuity with Geo-Replication

One great reason to move to Azure is the ease with which you can setup and manage disaster recovery (DR), high availability (HA) and your overall business continuity plan (BCP). And in April of 2016, Microsoft announced support for geo-replication for all service tiers.

Great, so where to get started? has posted a great beginner article that discusses Geo-Replication. You can think of Geo-Replication as either log-shipping or mirroring for the Azure SQL Database environment, but either way, one benefit is that the passive secondary databases have three distinct benefits:

  1. Readability!  the secondaries are readable.
  2. Multiple passive secondaries
  3. A possible lower cost that the primary
You can find Simple-Talk's report at SQL Database: How to Configure Active Geo-Replication.

No comments: