MsDTc on each node feasibly?

Is there a possibility to create on each node a MSDTC resource (even local on
each server)?
When you talk about a MSDTC resource, I assume you are talking about it as a
cluster resource. There is only one MSDTC resource in a cluster, not one for
each node.
What may be the reason you want it on each node?
Linchi
"Walter" <Walter@.discussions.microsoft.com> wrote in message
news:F712ECF3-D326-4CCC-8BCD-AA2425A6B503@.microsoft.com...
> Is there a possibility to create on each node a MSDTC resource (even local
> on
> each server)?
|||Thanks for the confirmation. The reason is I like to create a DB env.
active/active for our application that needs MsDTc. The first node DB for
the application and the second node for reporting and is a replicata of the
first DB.
Do you have maybe a solution for this?
Many thanks in advance,
Walter
"Linchi Shea" schreef:

> When you talk about a MSDTC resource, I assume you are talking about it as a
> cluster resource. There is only one MSDTC resource in a cluster, not one for
> each node.
> What may be the reason you want it on each node?
> Linchi
> "Walter" <Walter@.discussions.microsoft.com> wrote in message
> news:F712ECF3-D326-4CCC-8BCD-AA2425A6B503@.microsoft.com...
>
>
|||You can have multiple SQL instances on a cluster. You still need only one
instance of MSDTC for the entire cluster. There are several techniques that
will allow you to create the shadow database for reporting. Replication and
Log shipping are the most popular. Each has its own advantages and
disatvantages, so it is important to learn the capabilities of each.
Geoff N. Hiten
Senior Database Administrator
Microsoft SQL Server MVP
"Walter" <Walter@.discussions.microsoft.com> wrote in message
news:7CB2BC93-2B37-471B-BD4B-049A1F71658D@.microsoft.com...[vbcol=seagreen]
> Thanks for the confirmation. The reason is I like to create a DB env.
> active/active for our application that needs MsDTc. The first node DB for
> the application and the second node for reporting and is a replicata of
> the
> first DB.
> Do you have maybe a solution for this?
> Many thanks in advance,
> Walter
> "Linchi Shea" schreef: