Multiple Instance use of MSDTC

I have set up a
multiple instance
SQL server and I'm
trying to
understand how both
instances are able
to use the same
MSDTC resource.
Specifically,
Server 1 is the
primary host for
instance 1 (server
2 is the backup for
instance 1).
Server 2 is the
primary host for
instance 2 (server
1 is the backup for
instance 2).
How is Instance 1
on Server 1 running
correctly, if
Server 2 owns the
MSDTC resource?
I admit this is
more of a knowledge
question than a
troubleshooting
request, but any
guidance for future
troubleshooting
would be greatly
appreciated.
Thanks!
It is because the MSDTC resource is a cluster resource, not a local
resource. When you set up the cluster and install MSDTC to the cluster, all
the local MSDTC calls on each node are redirected to the clustered MSDTC
resource. The actual hosts of the resource and the SQL instances do not
matter.
Geoff N. Hiten
Senior Database Administrator
Microsoft SQL Server MVP
"Howard" <mansbachh@.hotmail.com> wrote in message
news:dq6q0d$1d0c$1@.news.rtcomm.ru...
>I have set up a
> multiple instance
> SQL server and I'm
> trying to
> understand how both
> instances are able
> to use the same
> MSDTC resource.
>
> Specifically,
> Server 1 is the
> primary host for
> instance 1 (server
> 2 is the backup for
> instance 1).
> Server 2 is the
> primary host for
> instance 2 (server
> 1 is the backup for
> instance 2).
> How is Instance 1
> on Server 1 running
> correctly, if
> Server 2 owns the
> MSDTC resource?
> I admit this is
> more of a knowledge
> question than a
> troubleshooting
> request, but any
> guidance for future
> troubleshooting
> would be greatly
> appreciated.
> Thanks!