Groups | Blog | Home
all groups > sql server clustering > may 2005 >

sql server clustering : MSDTC


Mohd Hidayat via SQLMonster.com
5/31/2005 12:00:00 AM
Hi all,

I'm new to clustering. Just some question to ask u all.

Do we have to configure separate static ip, network name and physical disk
for the MSDTC?

Or we can use the same static ip, network name and physical disk(Q:quorum
disk) that we configure for server clustering?

Appreciate ur help.

Tks

--
Geoff N. Hiten
5/31/2005 1:37:13 PM
Current best practice recommendations from Microsoft say to put MSDTC in its
own virtual server. therefore you will need a static IP addres, network
name, and physical disk. It is possible to use the Quorum disk and group
but it is not recommended. If you expect a low volume of Distributed
Transactions, you should be OK sharing one device.

Geoff N. Hiten
Microsoft SQL Server MVP


"Mohd Hidayat via SQLMonster.com" <forum@nospam.SQLMonster.com> wrote in
message news:947e91d07767474e88186ebbb5ed1539@SQLMonster.com...
[quoted text, click to view]

Charles Tolento
5/31/2005 3:54:53 PM
Mohd

It is recommended to create a new group with disk, ip, and name resources
available for the MSDTC resource. It is acceptable to use an existing group
if you do not have the resource capasity.

http://support.microsoft.com/default.aspx?scid=kb;en-us;301600

Regards

CT

[quoted text, click to view]
Tom Moreau
5/31/2005 8:22:43 PM
You got it right. the only other thing I'd add is the SQL hotfix after
applying SQL SP3a:

http://support.microsoft.com/default.aspx?scid=kb;en-us;821277

--
Tom

----------------------------------------------------
Thomas A. Moreau, BSc, PhD, MCSE, MCDBA
SQL Server MVP
Columnist, SQL Server Professional
Toronto, ON Canada
www.pinpub.com
..
[quoted text, click to view]
Hi guys,

Tks a million for your prompt reply. I have another question to ask u guys.
What are the order of installing server and sql clustering?

Is it W2k3sp1,MSCS,MSDTC,SQL,SQLsp3?

Tks once again for your help.

--
Message posted via http://www.sqlmonster.com
Mohd Hidayat via SQLMonster.com
5/31/2005 11:24:24 PM
Hi guys,

Tks a million for your prompt reply. I have another question to ask u guys.
What are the order of installing server and sql clustering?

Is it W2k3sp1,MSCS,MSDTC,SQL,SQLsp3?

Tks once again for your help.

--
AddThis Social Bookmark Button