September 21, 2010 at 2:38 am
Hi, SQL Server 2008 cluster on windows 2008 cluster - unfortunately I have installed MSDTC on one of the shared discs,
can I leave it as it is or it will be better to modify windows cluster prior to starting with the sql cluster?
September 21, 2010 at 2:51 am
Are you planning to Host web application, along with SQL server cluster ?
In case you accidentally left it there and not plan to use MSDTC service then it should not be any issue.
Cheer Satish 🙂
September 21, 2010 at 2:54 am
not really,
but we will be running SSIS on the SQL Server
September 21, 2010 at 7:22 am
If you install Microsoft Distributed Transaction Coordinator (MS DTC) in your SQL Server group and you have other resources that are dependent on MS DTC, MS DTC will not be available if this group is offline or during a failover. Microsoft recommends that you put MS DTC in its own group with its own physical disk resource, if it is possible.
you can find more information at How to: Add Dependencies to a SQL Server Resource ( http://msdn.microsoft.com/en-us/library/ms177447.aspx )
September 22, 2010 at 9:52 am
Halcyon (9/21/2010)
If you install Microsoft Distributed Transaction Coordinator (MS DTC) in your SQL Server group and you have other resources that are dependent on MS DTC, MS DTC will not be available if this group is offline or during a failover.
This is not quite true, With previous versions of Windows you could only have 1 clustered DTC resource.
However, On a Windows 2008 cluster it is perfectly viable to create a clustered DTC resource for each SQL Server cluster group, as Windows 2008 clusters allow you to have mulitple clustered DTC services!
😎
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
September 29, 2010 at 9:39 am
Hello,
I am just currently sorting out my MSDTC drives as well, I have decided to have 2 separate physical disks for 2 MSDTC groups, I was wondering whether to leave them as stand alone (different drive letter on each node) or cluster them. I am doing an active/active setup and the idea was to have a separate MSDTC resource for each node, so should I now cluster them as suggested earlier in the thread or have I misunderstood?
Regards,
D.
September 29, 2010 at 10:53 am
Duran
you add the disks as cluster resources and create a clustered DTC app for each one you want to deploy. You could even create them in the SQL groups they will service if you want, that way they will offline and move with the SQL Server resources.
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
September 30, 2010 at 4:16 am
Hi Perry,
Thank you for getting back. That sounds like a great plan, when you say I can create them in the SQL server groups they will service so they will offline and move with the SQL server resources, would I cluster the disks the normal way, install DTC and then add or create the groups when I start loading on the SQL instances? I am not sure of the order or the steps used here.
Regards,
D.
September 30, 2010 at 8:12 am
Pre create the empty service\application and then fill it with the appropriate resources (disk, DTC IP, DTC NAME, DTC service) and then install SQL Server 2008 selecting the pre created resource group when prompted.
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
October 6, 2010 at 10:18 am
Hello Perry,
I am trying to put your suggestion into action but I am having some trouble adding a disk for the DTC groups. I have created the cluster, the quorum all got stored into the correct drive and the 2 larger drives for logs and data are there. But if I try to add another disk for the DTC it does not show up when I try to add the extra disk, I just get an error saying that no suitable drives for clustering were found.
The disk shows up on both nodes in disk manager and have the same drive letter on both, its also basic. I've had a look on the web, but I have not found anyone who has had a similar or same problem, am I missing something somewhere? Thank you again for any advice.
Kind Regards,
D.
October 6, 2010 at 10:45 am
Duran (10/6/2010)
when I try to add the extra disk, I just get an error saying that no suitable drives for clustering were found.
is the drive online and formatted?
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
October 6, 2010 at 11:09 am
Did you add the disk as a resource first?
October 7, 2010 at 2:15 am
Hello,
Thank you both for taking the time to get back. Perry, yes the disk is formatted as a basic disk and online.
GH, I have looked up adding a resource since you posted, I have found articles pointing to 2003 but not 2008, I did not create a resource for the disks that are currently part of the cluster so I am unsure as to what to do here, I have noticed that the second node does not see the drive I am trying to add, so perhaps I need to arrange for an extra step in the SAN software?
Regards,
D.
October 7, 2010 at 3:45 am
Go into failover cluster manager and expand the cluster. Right click Storage and select Add Disk!
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
October 7, 2010 at 4:01 am
Hi Perry,
I have tried that, but I receive a dialogue box explaining that there were no drives found that are suitable for clustering.
Regards,
D.
Viewing 15 posts - 1 through 15 (of 39 total)
You must be logged in to reply to this topic. Login to reply