| Author |
MsDTc on each node feasibly?
|
|
| Walter 2005-11-09, 1:23 pm |
| Is there a possibility to create on each node a MSDTC resource (even local on
each server)?
| |
| Linchi Shea 2005-11-10, 3:23 am |
| 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@microso
ft.com...
> Is there a possibility to create on each node a MSDTC resource (even local
> on
> each server)?
| |
| Walter 2005-11-10, 3:23 am |
| 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@microso
ft.com...
>
>
>
| |
| Geoff N. Hiten 2005-11-10, 9:23 am |
| 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@microso
ft.com...[color=darkred]
> 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:
>
|
|
|
|