Solved

SQL server in a Hyper-V cluster

Posted on 2015-02-20
2
146 Views
Last Modified: 2015-02-23
hello experts
I want to configure HA for one application that is using an SQL database . I created my cluster every thing is OK .

My idea is to create an Hyper-V VM in the cluster env and install SQL on it (Non Clustered) and put the databases files in a Shared disk . so that when one node fails the VM can continue to the other Node

Would it work?

I saw that there is an option to install SQL for cluster but not being an expert of SQL I'm a bit reluctant to go that way
0
Comment
Question by:gazambey
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
2 Comments
 
LVL 9

Expert Comment

by:RantCan
ID: 40623201
In this scenario, you are simply engineering the Failover on the Hyper-v side, not in the native SQL clustering.
Sounds right; I recommend validating through testing.
0
 
LVL 3

Accepted Solution

by:
smilieface earned 500 total points
ID: 40624919
Yes, that should work. We use the same in VMWare.

So long as all the disks etc. are part of the shared infrastructure then it should fail over.

Note - this can give better uptimes than SQL Clustering as you don't have to restart when the SQL Instance "fails" over.

Warning - SQL goes down when the VM gets rebooted, e.g. for Windows patches etc. To avoid that you can do SQL Clustering on top of Virtualisation.

If you are genuinely looking for a highly available environment then you may need to get someone in who can help you put together a full solution.
0

Featured Post

Free Tool: Postgres Monitoring System

A PHP and Perl based system to collect and display usage statistics from PostgreSQL databases.

One of a set of tools we are providing to everyone as a way of saying thank you for being a part of the community.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Suggested Solutions

Title # Comments Views Activity
SQL Job Hung 17 35
Many to one in one row 2 35
Cannot promote server to domain because of forest functional level 3 39
Need help with a query 14 34
This article shows gives you an overview on SQL Server 2016 row level security. You will also get to know the usages of row-level-security and how it works
Previously, on our Nano Server Deployment series, we've created a new nano server image and deployed it on a physical server in part 2. Now we will go through configuration.
Via a live example, show how to extract information from SQL Server on Database, Connection and Server properties
Viewers will learn how to use the INSERT statement to insert data into their tables. It will also introduce the NULL statement, to show them what happens when no value is giving for any given column.

740 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question