SharePoint 2019 Always on high availability secondary replica issue

SGH 1,226 Reputation points
2021-03-03T10:48:46.153+00:00

There had been issues when secondary database replica was made primary (Always on High Availability for SQL Server 2017 with SharePoint 2019)

  • Saving a list form takes long time.
  • Workflows get canceled or takes long time and so on

After the windows update on Primary Replica, the server is restarted. During this process, availability group went offline and secondary which was acting as primary is disconnected. The service was down for few minutes (primary replica restart time).

Failover shows everything fine but when primary was shutdown, secondary stopped working.

SharePoint Server Management
SharePoint Server Management
SharePoint Server: A family of Microsoft on-premises document management and storage systems.Management: The act or process of organizing, handling, directing or controlling something.
2,817 questions
0 comments

1 answer

Sort by: Most helpful
Most helpful Newest Oldest
  1. Echo Du_MSFT 17,116 Reputation points
    2021-03-04T03:06:53.153+00:00

    Hello @SGH ，

    Please perform the following troubleshooting:

    1.Please make sure that the failover is successful? If the failover is successful, the original secondary node is shown in the figure below:

    74081-sql.jpg

    2.Are you configure automatic failover? If not, then when the primary node is shut down, the secondary node will not automatically become the primary node.

    If possible, please attach detailed screenshots. This helps us to better slove with problem.

    Thanks,
    Echo Du

    ================

    If an 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.