Failover of a S2S VPN

Hasan Kerem Kumru 60 Reputation points

I have an azure sql server and database on my primary UK South region and also i have a sql failover group in UK West region and both regions connect with vnet peering. My primary region connected with the on prem server with VPN Gateway for the data I/O. Now i want resilency on my infrastructure and if my primary region down, then secondary region automatically becomes the primary region. Can I add a secondary region on my vpn gateway, then switch and connect the on-prem when the primary fails. How can i achive this?

Azure VPN Gateway
Azure VPN Gateway
An Azure service that enables the connection of on-premises networks to Azure through site-to-site virtual private networks.
1,359 questions
SQL Server
SQL Server
A family of Microsoft relational database management and analysis systems for e-commerce, line-of-business, and data warehousing solutions.
12,581 questions
0 comments No comments
{count} votes

Accepted answer
  1. Marcin Policht 7,870 Reputation points MVP

    You can use any of the solutions described in

    If you want the primary/standby on-prem, you'd need to implement automatic routing updates in your on-prem environment



0 additional answers

Sort by: Most helpful