In a previous article I described how to configure an Azure SQL database failover group for high availability across multiple regions. But what if you want to limit network traffic to a database in this failover group to only your private networks? In this article I show how to make a SQL database failover group reachable via the Private Link service and make sure the database stays reachable after a failover.

With an Azure SQL Database, Microsoft is already providing high availability with an SLA of at least 99.99%. But if you want to prevent to be affected by a large regional event or want to meet regulatory demands to be able to execute failovers to another region, enabling a failover group is the solution for you. In this article I will show you how to create a SQL database failover group in two regions using the Azure CLI.