question

sajithgh avatar image
0 Votes"
sajithgh asked ·

SharePoint 2019 Always on high availability secondary replica issue

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.

office-sharepoint-server-administration
10 |1000 characters needed characters left characters exceeded
Toggle Comment visibility. Current Visibility: Visible to all users

Up to 10 attachments (including images) can be used with a maximum of 3.0 MiB each and 30.0 MiB total.

1 Answer

EchoDu-MSFT avatar image
0 Votes"
EchoDu-MSFT answered ·

Hello @sajithgh ，

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.





sql.jpg (24.1 KiB)
· 2 ·
10 |1000 characters needed characters left characters exceeded
Toggle Comment visibility. Current Visibility: Visible to all users

Up to 10 attachments (including images) can be used with a maximum of 3.0 MiB each and 30.0 MiB total.

sajithgh avatar image sajithgh ·

From the secondary replica, File Witness Share is not accessible.

0 Votes 0 ·
EchoDu-MSFT avatar image EchoDu-MSFT sajithgh ·

Hi @sajithgh ，

Thanks for you reply.

Can you provide detailed error information or screenshots? For example, Windows cluster log error message.

This helps us better understand the problem and provide efficient solutions.

Thanks,
Echo Du

0 Votes 0 ·