From the course: Microsoft Azure Database Administrator Associate (DP-300) Cert Prep by Microsoft Press

Unlock this course with a free trial

Join today to access over 25,300 courses taught by industry experts.

Configure failover groups

Configure failover groups

From the course: Microsoft Azure Database Administrator Associate (DP-300) Cert Prep by Microsoft Press

Start my 1-month free trial Buy for my team

Configure failover groups

“

- Welcome back. This is lesson 15.3, Configure Failover Groups. Failover Groups is a feature of Azure SQL Database that lets you manage the replication and failover of one or more databases on a logical server to another logical server in another region. While geo-replication is configured at the database level, failover groups is configured at the server level. This lets you choose all or a subset of user databases to include in the failover group. The benefit of this is that instead of managing replication at the database level, you can simplify management and deployment of a group of geo-replicated databases instead of at an individual level. So failover groups provide read-write and read-only listener endpoints that stay the same even during a failover or even during a geo-failover. You don't have to change the connections strings of your application after a geo-failover because the connections are automatically routed to the current primary. So let's configure a failover group…

Contents