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

--
Message posted via http://www.sqlmonster.com

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 (AT) nospam (DOT) SQLMonster.com> wrote in
message news:947e91d07767474e88186ebbb5ed1539 (AT) SQLMonster (DOT) com...

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...b;en-us;301600

Regards

CT

"Mohd Hidayat via SQLMonster.com" wrote:

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

You got it right. the only other thing I'd add is the SQL hotfix after
applying SQL SP3a:

http://support.microsoft.com/default...b;en-us;821277

--
Tom

----------------------------------------------------
Thomas A. Moreau, BSc, PhD, MCSE, MCDBA
SQL Server MVP
Columnist, SQL Server Professional
Toronto, ON Canada
www.pinpub.com
..
"Mohd Hidayat via SQLMonster.com" <forum (AT) SQLMonster (DOT) com> wrote

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