SQL Server 2019 Highly Available Cluster - Setup

Tolo, David 1 Reputation point
2020-08-17T14:33:35.027+00:00

I have a Hyper-v Cluster and would like a recipe for adding a highly available SQL role

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,580 questions
{count} votes

3 answers

Sort by: Most helpful
  1. Sreekanth Madambath 86 Reputation points
    2020-08-17T15:50:15.653+00:00

    Please share more details about your requirement.

    0 comments No comments

  2. AmeliaGu-MSFT 13,976 Reputation points Microsoft Vendor
    2020-08-18T06:18:53.81+00:00

    Hi ToloDavid-7159,

    If you want to configure SQL Server failover cluster, please refer to the following articles which might help:

    Install a clustered instance – step-by-step

    Always On Failover Cluster Instances (SQL Server)

    If you want to configure Always On availability group, please refer to:

    Configuring a SQL Server AlwaysOn High Availability Group

    Always On availability groups: a high-availability and disaster-recovery solution

    If you have any other questions, please let us know.

    Best Regards,
    Amelia

    0 comments No comments

  3. Alex Bykovskyi 2,006 Reputation points
    2020-08-23T15:55:15.643+00:00

    Hey,

    You can deploy SQL Server FCI, as mentioned in the answers above. The following guide can walk you through the configuration process:
    https://www.starwindsoftware.com/resource-library/starwind-virtual-san-installing-and-configuring-sql-server-2019-tp-failover-cluster-instance-on-windows-server-2016/

    Cheers,

    Alex Bykovskyi

    StarWind Software

    Note: Posts are provided “AS IS” without warranty of any kind, either expressed or implied, including but not limited to the implied warranties of merchantability and/or fitness for a particular purpose.

    0 comments No comments

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.