Click here to monitor SSC
SQLServerCentral is supported by Redgate
 
Log in  ::  Register  ::  Not logged in
 
 
 


How to create a SQL 2012 Failover cluster using VMs?


How to create a SQL 2012 Failover cluster using VMs?

Author
Message
APA0876
APA0876
SSC-Enthusiastic
SSC-Enthusiastic (150 reputation)SSC-Enthusiastic (150 reputation)SSC-Enthusiastic (150 reputation)SSC-Enthusiastic (150 reputation)SSC-Enthusiastic (150 reputation)SSC-Enthusiastic (150 reputation)SSC-Enthusiastic (150 reputation)SSC-Enthusiastic (150 reputation)

Group: General Forum Members
Points: 150 Visits: 400
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
@SQLFRNDZ
@SQLFRNDZ
Mr or Mrs. 500
Mr or Mrs. 500 (523 reputation)Mr or Mrs. 500 (523 reputation)Mr or Mrs. 500 (523 reputation)Mr or Mrs. 500 (523 reputation)Mr or Mrs. 500 (523 reputation)Mr or Mrs. 500 (523 reputation)Mr or Mrs. 500 (523 reputation)Mr or Mrs. 500 (523 reputation)

Group: General Forum Members
Points: 523 Visits: 1176
If you are trying to achieve HA then make sure your 2 VMs are from different hosts. then configuring will be almost same as you configure the physical clustering.


--SQLFRNDZ

free_mascot
free_mascot
SSCrazy
SSCrazy (2.9K reputation)SSCrazy (2.9K reputation)SSCrazy (2.9K reputation)SSCrazy (2.9K reputation)SSCrazy (2.9K reputation)SSCrazy (2.9K reputation)SSCrazy (2.9K reputation)SSCrazy (2.9K reputation)

Group: General Forum Members
Points: 2879 Visits: 2235
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."
jasona.work
jasona.work
SSCommitted
SSCommitted (1.9K reputation)SSCommitted (1.9K reputation)SSCommitted (1.9K reputation)SSCommitted (1.9K reputation)SSCommitted (1.9K reputation)SSCommitted (1.9K reputation)SSCommitted (1.9K reputation)SSCommitted (1.9K reputation)

Group: General Forum Members
Points: 1906 Visits: 10944
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.
Perry Whittle
Perry Whittle
SSCrazy Eights
SSCrazy Eights (8.8K reputation)SSCrazy Eights (8.8K reputation)SSCrazy Eights (8.8K reputation)SSCrazy Eights (8.8K reputation)SSCrazy Eights (8.8K reputation)SSCrazy Eights (8.8K reputation)SSCrazy Eights (8.8K reputation)SSCrazy Eights (8.8K reputation)

Group: General Forum Members
Points: 8784 Visits: 16558
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

Part1
Part2
Part3

-----------------------------------------------------------------------------------------------------------

"Ya can't make an omelette without breaking just a few eggs" ;-)
APA0876
APA0876
SSC-Enthusiastic
SSC-Enthusiastic (150 reputation)SSC-Enthusiastic (150 reputation)SSC-Enthusiastic (150 reputation)SSC-Enthusiastic (150 reputation)SSC-Enthusiastic (150 reputation)SSC-Enthusiastic (150 reputation)SSC-Enthusiastic (150 reputation)SSC-Enthusiastic (150 reputation)

Group: General Forum Members
Points: 150 Visits: 400
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
Perry Whittle
Perry Whittle
SSCrazy Eights
SSCrazy Eights (8.8K reputation)SSCrazy Eights (8.8K reputation)SSCrazy Eights (8.8K reputation)SSCrazy Eights (8.8K reputation)SSCrazy Eights (8.8K reputation)SSCrazy Eights (8.8K reputation)SSCrazy Eights (8.8K reputation)SSCrazy Eights (8.8K reputation)

Group: General Forum Members
Points: 8784 Visits: 16558
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" ;-)
APA0876
APA0876
SSC-Enthusiastic
SSC-Enthusiastic (150 reputation)SSC-Enthusiastic (150 reputation)SSC-Enthusiastic (150 reputation)SSC-Enthusiastic (150 reputation)SSC-Enthusiastic (150 reputation)SSC-Enthusiastic (150 reputation)SSC-Enthusiastic (150 reputation)SSC-Enthusiastic (150 reputation)

Group: General Forum Members
Points: 150 Visits: 400
Yes I'm reviewing them
Thanks
Perry Whittle
Perry Whittle
SSCrazy Eights
SSCrazy Eights (8.8K reputation)SSCrazy Eights (8.8K reputation)SSCrazy Eights (8.8K reputation)SSCrazy Eights (8.8K reputation)SSCrazy Eights (8.8K reputation)SSCrazy Eights (8.8K reputation)SSCrazy Eights (8.8K reputation)SSCrazy Eights (8.8K reputation)

Group: General Forum Members
Points: 8784 Visits: 16558
APA0876 (5/6/2014)
Yes I'm reviewing them
Thanks

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" ;-)
humbleDBA
humbleDBA
SSC Veteran
SSC Veteran (220 reputation)SSC Veteran (220 reputation)SSC Veteran (220 reputation)SSC Veteran (220 reputation)SSC Veteran (220 reputation)SSC Veteran (220 reputation)SSC Veteran (220 reputation)SSC Veteran (220 reputation)

Group: General Forum Members
Points: 220 Visits: 1500
Perry Whittle (5/6/2014)


Check my guide on this site at the following links

Part1
Part2
Part3


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. :-)
Go


Permissions

You can't post new topics.
You can't post topic replies.
You can't post new polls.
You can't post replies to polls.
You can't edit your own topics.
You can't delete your own topics.
You can't edit other topics.
You can't delete other topics.
You can't edit your own posts.
You can't edit other posts.
You can't delete your own posts.
You can't delete other posts.
You can't post events.
You can't edit your own events.
You can't edit other events.
You can't delete your own events.
You can't delete other events.
You can't send private messages.
You can't send emails.
You can read topics.
You can't vote in polls.
You can't upload attachments.
You can download attachments.
You can't post HTML code.
You can't edit HTML code.
You can't post IFCode.
You can't post JavaScript.
You can post emoticons.
You can't post or upload images.

Select a forum

































































































































































SQLServerCentral


Search