Patching issue in SharePoint with SQL Basic always on environment

Nur Hossain 282 Reputation points
2023-03-16T06:22:14.4933333+00:00

We have SharePoint 2019 in MS SQL server Basic Always On cluster.

we are facing issues like when we need to be patching in SharePoint server.

needs to remove secondary SQL node from SQL basic always on cluster and re-add after patching.

Is there any idea?

Thank You

Nur Hossain

SharePoint Server
SharePoint Server
A family of Microsoft on-premises document management and storage systems.
2,197 questions
SQL Server
SQL Server
A family of Microsoft relational database management and analysis systems for e-commerce, line-of-business, and data warehousing solutions.
12,585 questions
SharePoint
SharePoint
A group of Microsoft Products and technologies used for sharing and managing content, knowledge, and applications.
9,520 questions
SQL Server Integration Services
SQL Server Integration Services
A Microsoft platform for building enterprise-level data integration and data transformations solutions.
2,446 questions
{count} votes

Accepted answer
  1. Seeya Xi-MSFT 16,436 Reputation points
    2023-03-16T07:33:12.4733333+00:00

    Hi @Nur Hossain,

    Yes, there is a way to minimize downtime during patching in SharePoint 2019 with SQL Server Basic Always On cluster.

    One approach is to use an approach called "rolling upgrade" or "rolling patching." In this approach, you patch one server at a time, starting with the secondary node, which can be removed from the SQL Server Basic Always On cluster, patched, and then added back to the cluster. Once the secondary node is patched and added back to the cluster, you can failover the cluster to make the secondary node the primary node, and then repeat the process for the previous primary node.

    Please refer to MS document:

    https://learn.microsoft.com/en-us/windows-server/failover-clustering/cluster-operating-system-rolling-upgrade

    User's image

    Best regards,

    Seeya


    If the answer is the right solution, please click "Accept Answer" and kindly upvote it. If you have extra questions about this answer, please click "Comment".

    0 comments No comments

0 additional answers

Sort by: Most helpful