dbTalk Databases Forums  

MSDTC AND SQL using the same cluster disk

microsoft.public.sqlserver.clustering microsoft.public.sqlserver.clustering


Discuss MSDTC AND SQL using the same cluster disk in the microsoft.public.sqlserver.clustering forum.



Reply
 
Thread Tools Display Modes
  #1  
Old   
Walidg
 
Posts: n/a

Default MSDTC AND SQL using the same cluster disk - 05-27-2010 , 04:01 PM






I added the MSDTC service in a 2 node WIN2K8 cluster using one of the 2
clustered disks. While I try to install SQL fail-over cluster - it tells me
that I can not use the disk since the MSDTC service is dependent on it. How
do I get around this? I want to be able to use the same disk for both MSDTC
and SQL. I have 2 disks - one for SQL logs and one for SQL Data.

Thanks in advance,

Walid

Reply With Quote
  #2  
Old   
Russ Kaufmann
 
Posts: n/a

Default Re: MSDTC AND SQL using the same cluster disk - 05-27-2010 , 11:23 PM






"Walidg" <walidg (AT) newsgroup (DOT) nospam> wrote

Quote:
I added the MSDTC service in a 2 node WIN2K8 cluster using one of the 2
clustered disks. While I try to install SQL fail-over cluster - it tells
me
that I can not use the disk since the MSDTC service is dependent on it.
How
do I get around this? I want to be able to use the same disk for both
MSDTC
and SQL. I have 2 disks - one for SQL logs and one for SQL Data.
This is expected behavior. You need to have separate physical disk resources
for your SQL instance.

What you can do, however, is remove the MSDTC and then recreate it using the
quorum disk for the MSDTC. This is supported, but it may be an issue for
performance if you use MSDTC extensively.

--
Russ Kaufmann
MVP, MCT, MCITP x7, MCTS x9, MCSE x4, CTT+
ClusterHelp.com, a Microsoft Gold Certified Partner

Email:russ (AT) clusterhelp (DOT) com
http://www.clusterhelp.com
Blog: http://msmvps.com/clusterhelp

Reply With Quote
  #3  
Old   
Walidg
 
Posts: n/a

Default Re: MSDTC AND SQL using the same cluster disk - 06-09-2010 , 10:34 AM



Thanks, Russ. Actually what I did was remove the MSTDC service - install SQL
and then create the MSDTC serivice in the SQL resource group. This way, I
was able to use the same disk for both SQL and MSDTC.

"Russ Kaufmann" wrote:

Quote:
"Walidg" <walidg (AT) newsgroup (DOT) nospam> wrote in message
news:896E482D-7B5F-47C3-8CDD-46A551895CA2 (AT) microsoft (DOT) com...
I added the MSDTC service in a 2 node WIN2K8 cluster using one of the 2
clustered disks. While I try to install SQL fail-over cluster - it tells
me
that I can not use the disk since the MSDTC service is dependent on it.
How
do I get around this? I want to be able to use the same disk for both
MSDTC
and SQL. I have 2 disks - one for SQL logs and one for SQL Data.

This is expected behavior. You need to have separate physical disk resources
for your SQL instance.

What you can do, however, is remove the MSDTC and then recreate it using the
quorum disk for the MSDTC. This is supported, but it may be an issue for
performance if you use MSDTC extensively.

--
Russ Kaufmann
MVP, MCT, MCITP x7, MCTS x9, MCSE x4, CTT+
ClusterHelp.com, a Microsoft Gold Certified Partner

Email:russ (AT) clusterhelp (DOT) com
http://www.clusterhelp.com
Blog: http://msmvps.com/clusterhelp

Reply With Quote
Reply




Thread Tools
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

vB code is On
Smilies are On
[IMG] code is On
HTML code is Off



Powered by vBulletin Version 3.5.3
Copyright ©2000 - 2012, Jelsoft Enterprises Ltd.