(SQL) Tip of the Day: Business continuity during a SQL Azure Outage

Today’s (SQL) Tip…

We have two options during an outage Geo-Replication and Geo-Restore.

If the database has geo-replication,  failover to the geo-secondary (https://msdn.microsoft.com/en-us/library/azure/hh852669.aspx).   There is a risk of data loss during failover, which is documented in the link.    Expected data loss is <2s of transactions.

Perform a geo-restore to another region (https://msdn.microsoft.com/en-us/library/azure/hh852669.aspx), with up to 5 minutes of data loss.

After this you will most likely need to change your application connection string.