-1

I'm doing some testing with availability group in SQL Server. When I'm on the primary replica, I can see all replica nodes have a refresh icon on them.

But when I check on a secondary replica, all other nodes have a question mark on their replica names. What does it mean?

Btw, I'm using SSMS 18 with SQL Server 2022.

1
  • It typically indicates that the availability state of those replicas is currently unknown or cannot be determined. Can you check the status/state of the replicas? To get the actual availability state of the replicas, you can right-click on each replica, select "Properties," and navigate to the "Availability" tab. The availability state will be displayed there, providing more detailed information about the synchronization status of the replicas.
    – kesadae11
    Jun 24, 2023 at 1:06

1 Answer 1

1

Each secondary replica connects to the primary, and so the instance hosting the primary node knows the state of all the replicas.

The secondary replicas don't communicate directly with each other.

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service and acknowledge you have read our privacy policy.

Not the answer you're looking for? Browse other questions tagged or ask your own question.