dbTalk Databases Forums  

How to move MSDTC to another Cluster Group?

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


Discuss How to move MSDTC to another Cluster Group? in the microsoft.public.sqlserver.clustering forum.



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

Default How to move MSDTC to another Cluster Group? - 09-08-2010 , 08:44 PM






Hello,

We have 2-node, 1-instance clsuter (64-bit Windows 2003 and 64-bit SQL
2005). We now want to add another sql instance. Currently, MSDTC resource is
under the existing sql cluster group.

We want to move it to a new its own cluster group, or move it to the cluster
group along with Quorum, Cluster name, cluster ip resources.

Is it as easy as removing from one cluster group and adding to another group?

Thanks,

Ada
--
SQL Server DBA

Reply With Quote
  #2  
Old   
sporren
 
Posts: n/a

Default RE: How to move MSDTC to another Cluster Group? - 09-09-2010 , 05:05 PM






Hi Ada,

We have that exact same configuration. 2-node (64-bit Windows 2003 and
64-bit SQL
2005).

We have MSDTC in its own group containing an IP, Network Name, Disk and the
MSDTC itself.

Do you have MSDTC on a disk that you share with your SQL instance? In this
case you will have to create a new disk and assign it to your new group and
move MSDTC here.

Then we have one group for each SQL instance and one for the base cluster
(Quorum, IP, Net Name)

"Ada" wrote:

Quote:
Hello,

We have 2-node, 1-instance clsuter (64-bit Windows 2003 and 64-bit SQL
2005). We now want to add another sql instance. Currently, MSDTC resource is
under the existing sql cluster group.

We want to move it to a new its own cluster group, or move it to the cluster
group along with Quorum, Cluster name, cluster ip resources.

Is it as easy as removing from one cluster group and adding to another group?

Thanks,

Ada
--
SQL Server DBA

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

Default RE: How to move MSDTC to another Cluster Group? - 09-10-2010 , 12:21 PM



"Do you have MSDTC on a disk that you share with your SQL instance?"

Yes. But we might have to use the cluster group since we may not have a
separate disk.

Thanks,

--
SQL Server DBA


"sporren" wrote:

Quote:
Hi Ada,

We have that exact same configuration. 2-node (64-bit Windows 2003 and
64-bit SQL
2005).

We have MSDTC in its own group containing an IP, Network Name, Disk and the
MSDTC itself.

Do you have MSDTC on a disk that you share with your SQL instance? In this
case you will have to create a new disk and assign it to your new group and
move MSDTC here.

Then we have one group for each SQL instance and one for the base cluster
(Quorum, IP, Net Name)

"Ada" wrote:

Hello,

We have 2-node, 1-instance clsuter (64-bit Windows 2003 and 64-bit SQL
2005). We now want to add another sql instance. Currently, MSDTC resource is
under the existing sql cluster group.

We want to move it to a new its own cluster group, or move it to the cluster
group along with Quorum, Cluster name, cluster ip resources.

Is it as easy as removing from one cluster group and adding to another group?

Thanks,

Ada
--
SQL Server DBA

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.