Replicate old Azure SQL database and keep same connection string

Question

Due to the recent Azure outage in Australia East, our Azure SQL databases located in AUE are down.

In the downtime, is there any way I can spin up an SQL database quickly using existing data, preferably keeping the same connection string? It can be from a different region than AUE.

Answer 1

@Han Moe Htet

If you have configure your SQL Database to use active geo-replication, which provides a secondary database in a different region that is updated in real-time with changes made to the primary database. In the event of a primary datacenter outage, you can failover to the secondary database to minimize downtime.

If you have not enabled active geo-replication or auto-failover groups, then you can use geo-restore to recover from an outage. Geo-restore uses geo-replicated backups as the source. You can restore a database on any logical server in any Azure region from the most recent geo-replicated backups. You can request a geo-restore even if an outage has made the database or the entire region inaccessible.

Please find Outage recovery guidance reference document
https://learn.microsoft.com/en-us/azure/azure-sql/database/disaster-recovery-guidance?view=azuresql#outage-recovery-guidance

Thank you!

Answer 2

@Han Moe Htet Thank you for reaching out.

I'm sorry to hear that you are experiencing issue with your Azure SQL databases in Australia East due to a recent outage in that region.

Answer provided by @RahulRandive looks correct to me as a suggestion and in addition to that.

If geo replication is setup, then you can failover to a secondary region that’s different from Australia East or you can geo restore the data in another region. All these are discussed in detail in the link above shared by @RahulRandive .

Connection string will be different if you are not dealing with failover groups.

Hope that helps you.

Regards,

Oury