sql server cluster - state of primary node is unknown on secondary node

Alibek Ismailov 26 Reputation points
2021-06-24T11:47:04.11+00:00

Hi, i have sql cluster (always on) with 2 nodes. When 2nd node was turned off, i added a new db to Primary DB. After Secondary db was turned on, on Secondary db state of Primary db is unknown. Look screenshot for details. On Primary i see that Operational State of Secondary is Unknown.
What is wrong? Adding a new db on primary when secondary db was turned off broke cluster? How to recover cluster?
109036-capture.png

SQL Server
SQL Server
A family of Microsoft relational database management and analysis systems for e-commerce, line-of-business, and data warehousing solutions.
12,705 questions

2 answers

Sort by: Most helpful
Most helpful Newest Oldest
  1. CarrinWu-MSFT 6,851 Reputation points
    2021-06-25T06:20:45.757+00:00

    Hi @Alibek Ismailov ,

    Before you add a new database to an Existing Always On Availability Group, you should test on your staging environment first and make Full & Log backups for your databases. After that you could add a new database to your production environment. And there is no need to turn off your secondary replica when you add a new database. Please refer to Add a SQL Server Database to an Existing Always On Availability Group.

    The state of the local availability replica in availability group 'DB1' has changed from 'NOT_AVAILABLE' to 'RESOLVING_NORMAL'.

    This link shows a similar error, please refer to it to get the steps.

    Best regards,
    Carrin

    If the answer is helpful, please click "Accept Answer" and upvote it.
    Note: Please follow the steps in our documentation to enable e-mail notifications if you want to receive the related email notification for this thread.

    1 person found this answer helpful.
    0 comments
  2. Alibek Ismailov 26 Reputation points
    2021-06-28T04:07:53.477+00:00

    hi @CarrinWu-MSFT i found that it is normal state of cluster, secondary doesnt see state of primary, it shows like unknown. Also i found this: https://learn.microsoft.com/en-us/answers/questions/87199/availability-replica-server-with-question-status-a.html. Thx for help