Availability Replica - Server with question status and Role Unknown

Salves 501 Reputation points
2020-09-05T01:50:00.487+00:00

Hi,

after executing the manual faiolver procedure that was configured as asynchronous, we return to the initial scenario.

We return with the bases paused, wait for the synchronization and perform the failover manually again to the servers that were initially configured.

However, we noticed that the server icon in (Availability Replicas) that showed with circular arrows, now shows as blue interrogation.

In a Google search they say that this is normal by design, because of the status on the secondary server not getting information from the primary. Question mark icon.

Is that so?

22821-status1.jpg

22727-status3.jpg

Another situation we observed is that on the secondary server it only shows the status of the secondary, it does not show the same as the primary.

Is that so?

22757-status2.jpg

Another situation we observed is that when we enable asynchronous the database shows as (Synchronizing) and not (Synchronized) the same in the synchronous method when configured.

Is that so?

22822-status4.jpg

Thank you.

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

Accepted answer
  1. Shashank Singh 6,251 Reputation points
    2020-09-05T05:43:03.207+00:00

    This is totally normal, on secondary replica you would only see secondary mentioned on the server instance holding secondary replica. Secondary replica is in receiving mode and does not have information about which primary replica is so it does not mentioned primary replica and you see a question mark. On primary replica you will see all the information

    2 people found this answer helpful.

0 additional answers

Sort by: Most helpful

Your answer

Answers can be marked as Accepted Answers by the question author, which helps users to know the answer solved the author's problem.