Service Template - SQL Cluster
-
Tuesday, May 29, 2012 9:46 PM
Evening All,
I am wanting to create a service template that will include an SQL 2008 R2 failover cluster. I would like to provision dedicated luns for sysdb,syslogs,userdbs and userlogs. What would be the best method to complete this?
I can create a single SQL node with the lun mapped and create a vhd on top?
Thanks
Paul
All Replies
-
Wednesday, May 30, 2012 12:14 AM
Hello Paul,
As far as i know there is no options to make Guest SQL Cluster in VMM 2012.
Guest Clustering is not supported with luns, just can be made by ISCSI.
But good news , with Windows 2012 , we will be able to use LUN.
Sincerely,
Murat Demirkiran
If the post helps you and remember to click “Mark as Answer” on the post that helps you, and to click “Unmark as Answer” if a marked post does not actually answer your question. www.scvmm2012.com (TR Language) Please note that I'm not a Microsoft Representative or SpokesPerson.
- Marked As Answer by PaulSanders87 Wednesday, May 30, 2012 2:22 PM
-
Wednesday, May 30, 2012 5:42 AM
Hi, Paul
The service template does not support building SQL Cluster , the SQL Sysprep configuration works only for Single standalone SQL installation
Hikmat Kanaan Amman-Jordan MCSE
- Marked As Answer by PaulSanders87 Wednesday, May 30, 2012 2:22 PM
-
Wednesday, May 30, 2012 8:17 AM
Thanks both.
When using iSCSI, will this be from within the guest, or the actual host?
I can still create an sql cluster using SCORCH though, so shouldnt be a major show stopper.
Cheers
Paul
-
Wednesday, May 30, 2012 8:47 AM
The iSCSI, should be from within the guest , so that both SQL VM see the same storage
Hikmat Kanaan Amman-Jordan MCSE
-
Wednesday, May 30, 2012 2:23 PMThanks All
.png)
