14,494 questions
Please share more details about your requirement.
SQL Server 2019 Highly Available Cluster - Setup
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(32, 77%, 13%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3ETD%3C/text%3E%3C/svg%3E)
Tolo, David
1
Reputation point
I have a Hyper-v Cluster and would like a recipe for adding a highly available SQL role
SQL Server | Other
{count} votes
-
Shashank Singh 6,251 Reputation points2020-08-17T15:41:25.87+00:00 Are you planning to configure SQL FCI or SQL Server Availability Groups ? Need more information about what kind of HA/DR you are looking for
-
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(108.80000000000001, 46%, 20%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EAM%3C/text%3E%3C/svg%3E)
AmeliaGu-MSFT 14,006 Reputation points Microsoft External Staff2020-08-24T01:13:40.467+00:00 Hi ToloDavid-7159,
Did the answers help you?
Please feel free to let us know if you have any other question.
If you find any post in the thread is helpful, you could kindly accept it as answer. This would benefit the community, and encourage the community member to keep working on your issues.Best Regards,
Amelia
Sign in to comment
3 answers
Sort by: Most helpful
-
-
AmeliaGu-MSFT 14,006 Reputation points Microsoft External Staff
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 -
Alex Bykovskyi 2,241 Reputation points2020-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.