In this article, we will review how to set up auto-failover groups in Azure SQL Server and how failover group is different from active geo-replication in Azure. Auto-failover group is an Azure SQL database feature that replicates one or a group of databases to the secondary Azure SQL server in the cross-region. We cannot have a secondary server in the same region. This feature is used to failover all the databases in the failover group in case of disaster and the failover is automatic.
Read more »![Ranga Babu](https://s33046.pcdn.co/wp-content/uploads/2019/01/ranga.jpg)
![adding database to an existing failover group](https://s33046.pcdn.co/wp-content/uploads/2019/07/adding-database-to-an-existing-failover-group-624x311.png)