May 5, 2014 at 4:33 pm
Hi thanks before everything!, I have the following question that I hope you can oriented me:
How to create a SQL 2012 Failover cluster using VMs?
Thanks
APA
May 5, 2014 at 9:02 pm
May 5, 2014 at 10:44 pm
You can create the ISCSI drive on VM which shares the drive similar to SAN and proceed further. Also you can create two identical hardware for cluster and try always on.
---------------------------------------------------
"Thare are only 10 types of people in the world:
Those who understand binary, and those who don't."
May 6, 2014 at 5:35 am
My question would be, what is this for? Is this for a learning sandbox so you can get a feel for / practice setting up a fail-over cluster, or is this a QA environment at your workplace, or is this for a production system?
Each of those three will have a different answer, and more questions...
If it's just a learning / practice sandbox, then it depends on the hardware you have available...
It's possible to do this entirely within the hypervisor, if you have access to the right OS. Three VMs, two for SQL, one to function as an iSCSI Target for the shared storage. Or, if you have an external NAS device which supports iSCSI, you could do it with 2 VMs.
If this is for a work environment, now you need to find out what hardware is available, what sort of SLA are you looking at, etc.
Details matter...
The more details you provide, the more someone can help you.
May 6, 2014 at 7:16 am
APA0876 (5/5/2014)
Hi thanks before everything!, I have the following question that I hope you can oriented me:How to create a SQL 2012 Failover cluster using VMs?
Thanks
APA
Check my guide on this site at the following links
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
May 6, 2014 at 12:30 pm
Hi yes I agree,
This is going to be a production cluster, this company bought a software and the vendor is recommending to create a Virtual SQL Cluster, on Production .
what is the difference on the creation of a SQL cluster on sql server 2008 R2 and SQL Server 2012?
Thanks
May 6, 2014 at 4:45 pm
APA0876 (5/6/2014)
what is the difference on the creation of a SQL cluster on sql server 2008 R2 and SQL Server 2012?Thanks
The installer is pretty much the same with some slight differences for sql 2012, they both use a Windows Server Failover Cluster, so essentially no difference.
Have you checked my links for more detail?
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
May 6, 2014 at 4:48 pm
Yes I'm reviewing them
Thanks
May 6, 2014 at 4:50 pm
APA0876 (5/6/2014)
Yes I'm reviewing themThanks
OK, well if you're putting this into production ensure the hosts are well specced.
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
May 7, 2014 at 9:04 am
Perry Whittle (5/6/2014)
Check my guide on this site at the following links
Wow :w00t: ...missed this set of guides. At first glance, looks great - and I've used Starwind's free iSCSI SAN for a number of years now for development and testing, so good stuff.
Nice job Perry. 🙂
May 7, 2014 at 10:09 am
Keep an eye out for part 4 later this month , you'll love it.
Please don't forget to rate the articles if you found them useful
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
Viewing 11 posts - 1 through 10 (of 10 total)
You must be logged in to reply to this topic. Login to reply