Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
 
Log in  ::  Register  ::  Not logged in
 
 
 
        
Home       Members    Calendar    Who's On


Add to briefcase 12»»

How to create a SQL 2012 Failover cluster using VMs? Expand / Collapse
Author
Message
Posted Monday, May 5, 2014 4:33 PM
SSC-Enthusiastic

SSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-Enthusiastic

Group: General Forum Members
Last Login: Tuesday, June 17, 2014 1:39 PM
Points: 127, Visits: 300
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
Post #1567737
Posted Monday, May 5, 2014 9:02 PM This worked for the OP Answer marked as solution
SSC-Addicted

SSC-AddictedSSC-AddictedSSC-AddictedSSC-AddictedSSC-AddictedSSC-AddictedSSC-AddictedSSC-Addicted

Group: General Forum Members
Last Login: Today @ 9:50 AM
Points: 477, Visits: 1,053
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
Post #1567763
Posted Monday, May 5, 2014 10:44 PM This worked for the OP Answer marked as solution
SSCrazy

SSCrazySSCrazySSCrazySSCrazySSCrazySSCrazySSCrazySSCrazy

Group: General Forum Members
Last Login: Monday, July 21, 2014 2:56 AM
Points: 2,603, Visits: 2,061
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."
Post #1567770
Posted Tuesday, May 6, 2014 5:35 AM This worked for the OP Answer marked as solution


Right there with Babe

Right there with BabeRight there with BabeRight there with BabeRight there with BabeRight there with BabeRight there with BabeRight there with BabeRight there with Babe

Group: General Forum Members
Last Login: Today @ 5:34 PM
Points: 748, Visits: 5,519
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.
Post #1567881
Posted Tuesday, May 6, 2014 7:16 AM This worked for the OP Answer marked as solution


SSCertifiable

SSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiable

Group: General Forum Members
Last Login: Today @ 3:29 PM
Points: 6,745, Visits: 14,384
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"
Post #1567927
Posted Tuesday, May 6, 2014 12:30 PM
SSC-Enthusiastic

SSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-Enthusiastic

Group: General Forum Members
Last Login: Tuesday, June 17, 2014 1:39 PM
Points: 127, Visits: 300
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
Post #1568134
Posted Tuesday, May 6, 2014 4:45 PM This worked for the OP Answer marked as solution


SSCertifiable

SSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiable

Group: General Forum Members
Last Login: Today @ 3:29 PM
Points: 6,745, Visits: 14,384
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"
Post #1568227
Posted Tuesday, May 6, 2014 4:48 PM
SSC-Enthusiastic

SSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-Enthusiastic

Group: General Forum Members
Last Login: Tuesday, June 17, 2014 1:39 PM
Points: 127, Visits: 300
Yes I'm reviewing them
Thanks
Post #1568230
Posted Tuesday, May 6, 2014 4:50 PM


SSCertifiable

SSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiable

Group: General Forum Members
Last Login: Today @ 3:29 PM
Points: 6,745, Visits: 14,384
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"
Post #1568231
Posted Wednesday, May 7, 2014 9:04 AM


SSC Veteran

SSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC Veteran

Group: General Forum Members
Last Login: Tuesday, November 11, 2014 9:22 AM
Points: 216, Visits: 1,372
Perry Whittle (5/6/2014)


Check my guide on this site at the following links

Part1
Part2
Part3


Wow ...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.
Post #1568522
« Prev Topic | Next Topic »

Add to briefcase 12»»

Permissions Expand / Collapse