question on geo-replication and Failover groups on Azure SQL database

anil kumar 1,641 Reputation points
2021-02-04T11:35:55.143+00:00

Hi,

I configured GR and Failover group for my Azure Sql databases - could you please help with following questions ?

  1. I can run read queries on secondary databases configured for either GR or Failover groups but I am unable to see them in SSMS. I couldn't understand the reason behind it.
  2. I can make listener name by appending Azure SQL instance name, can I get both listeners (read-write and read only) details from Azure portal?
  3. Can I drop the primary database even if it is configured for GR or Failover group ? If yes, I think it should be mandated to first drop GR or Failover group than allow dropping of primary database.

Appreciate your insightful response. Thank you.

Azure SQL Database
0 comments No comments
{count} votes

Accepted answer
  1. Anurag Sharma 17,576 Reputation points
    2021-02-05T07:50:27.373+00:00

    Hi @anil kumar , welcome to Microsoft Q&A forum.

    Please find the replies below:

    1) You can set the 'ApplicationIntent=ReadOnly' in SSMS while connecting to the database and then you can use the below query to check if db is read-only:

    SELECT DATABASEPROPERTYEX(DB_NAME(), 'Updateability');  
    

    64473-image.png

    2) I could not locate anything on Azure portal but yes we can append the Azure SQL DNS name for listener. For secondaries we need to append 'secondary' as well.

    3) Yes we can drop the primary database but it will remove any linking between primary and secondary replicas. Better way to do that will be as mentioned in the article.

    Please let me know if this helps or we can discuss further.


    If answer helps, you can mark it as 'Accept Answer'

    64369-image.png


0 additional answers

Sort by: Most helpful