Share via

Best way to migrate SQL2017 nonclustered ReadScale to a true WSFC AOAG

Jac Thiessen 20 Reputation points
2024-09-16T20:14:57.4933333+00:00

We have a SQL2017 Enterprise Edition server that was setup without clustering with a Read Scale AG copy of DB's to another server. What is the best way to convert this to a true HA Availability Group with WSFC primary and secondary replicas? At this time, we are not upgrading SQL. The OS is currently Windows Server 2016 Datacenter. Are we able to just add clustering to the server and recreate the AG with HA? Or do we need to setup a new set of clustered servers and then migrate the DB's over? If so, then can we just simply add the new clustered server as a part of the old Read Scale AG and then fail it over to the new servers and then recreate the AG with HA capability? We are looking for the best way to get this system into a HA setup. 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,998 questions
Windows Server Clustering
Windows Server Clustering
Windows Server: A family of Microsoft server operating systems that support enterprise-level management, data storage, applications, and communications.Clustering: The grouping of multiple servers in a way that allows them to appear to be a single unit to client computers on a network. Clustering is a means of increasing network capacity, providing live backup in case one of the servers fails, and improving data security.
1,008 questions
Accepted answer
  1. Neuvi Jiang 1,460 Reputation points Microsoft Vendor
    2024-09-17T06:28:32.98+00:00

    Hi Jac Thiessen,

    Thank you for posting in the Q&A Forums.

    Install WSFC:

    Install the WSFC service on all servers participating in HA.

    Configure the WSFC cluster, including nodes, network, and shared storage (if required).

    Configure AlwaysOn AG:

    Enable the AlwaysOn Availability Group feature in SQL Server.

    Create a new availability group and add existing databases to the group.

    Configure synchronous or asynchronous commit mode, and failover policy.

    Test HA:

    Perform failover testing to ensure that the system works as expected.

    Monitor performance and adjust configurations to optimize performance.

    Best regards

    NeuviJ

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

    If the Answer is helpful, please click "Accept Answer" and upvote it.

    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.