Solved

SQL server in a Hyper-V cluster

Posted on 2015-02-20
2
154 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

Creating Instructional Tutorials  

For Any Use & On Any Platform

Contextual Guidance at the moment of need helps your employees/users adopt software o& achieve even the most complex tasks instantly. Boost knowledge retention, software adoption & employee engagement with easy solution.

Question has a verified solution.

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

Veeam Backup & Replication has added a new integration – Veeam Backup for Microsoft Office 365.  In this blog, we will discuss how you can benefit from Office 365 email backup with the Veeam’s new product and try to shed some light on the needs and …
In this article we will learn how to fix  “Cannot install SQL Server 2014 Service Pack 2: Unable to install windows installer msi file” error ?
Familiarize people with the process of utilizing SQL Server functions from within Microsoft Access. Microsoft Access is a very powerful client/server development tool. One of the SQL Server objects that you can interact with from within Microsoft Ac…
This videos aims to give the viewer a basic demonstration of how a user can query current session information by using the SYS_CONTEXT function

726 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