Am working on the Azure SQL with Auto-Failover Group, for this I created one SQL Server along with one database and I created another copy of database in another SQL Server which is created with the help of Geo-Replication in other region. For that, I created one failover group and working fine. But while working with this, some doubts were raised to me like:
My Primary region like East US has been collapses due unexpected disaster occurs, then what about my SQL Database and all my failover groups condition. Is it possible to recover them?
If I delete primary SQL Database, then what happen to my fail over group?
- If I delete my primary SQL server, then is it my fail over group work finely?
For doing the above, I followed the link
If you remove the primary the failover group is removed and the geo-replication is removed too. The secondary database will remain with no geo-replication configured. I just tested this on Azure portal.