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

Alibek Ismailov 21 Reputation points

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?

SQL Server
SQL Server
A family of Microsoft relational database management and analysis systems for e-commerce, line-of-business, and data warehousing solutions.
9,057 questions
{count} votes

2 answers

Sort by: Most helpful
  1. CarrinWu-MSFT 6,801 Reputation points

    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,

    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.
    No comments

  2. Alibek Ismailov 21 Reputation points

    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