Share via

Failover manual always on passage state

Alen Cappelletti 992 Reputation points
2021-07-26T08:30:02.223+00:00

Hi,
I'm looking for some links that show me the exact failover sequence between two nodes. I introduced some alerts in sql server and it seems to me that this is the movement between nodes. I'm curious to understand ... The primary was on SER-02 and I failed over to SER-01.

117825-image.png

Thanks ALEN

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,826 questions
0 comments
Accepted answer
  1. CathyJi-MSFT 22,206 Reputation points Microsoft Vendor
    2021-07-27T06:29:18.3+00:00

    Hi @Anonymous ,

    > I'm looking for some links that show me the exact failover sequence between two nodes.

    I do not find any blogs or documents that has the detail step information about this. But we can find the SQL AG failover detail process information from SQL server error log as below screenshots( these are only part of error log) from my environment. Node3\SQL 2019 is the primary node, node1\SQL 2019 is the secondary node. Suggest you doing a failover in your environment, and check the SQL server error log in your environment to get the answer.

    118193-screenshot-2021-07-27-142404.jpg

    118194-screenshot-2021-07-27-142526.jpg

    If the response is helpful, please click "Accept Answer" and upvote it, as this could help other community members looking for similar queries.

    0 comments

0 additional answers

Sort by: Most helpful
Most helpful Newest Oldest

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.