I am test my failover group for Azure SQL. Not sure if i am missing something obvious.
This is the scenario I am testing
I have a failovergroup configured on SRV1 with grace period 1hr, the primary db is DB1 and the secondary is in a different region and is DB2.
I have tested with the Failover option in Azure and that works. So now the Primary is DB2. I set the Primary back to DB1.
Now i went to SSMS and deleted DB1. I would have expected that the secondary would become the Primary , but this is not the case . Even after 1hr the secondary did not become the primary .
Is there something that i am not doing correctly ?
I believe if you delete the primary database from Azure portal, the secondary will just be deleted. As you actively delete the DB, It will not be considered as a failover action/case
What exactly did you delete though?