Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
snivek
Starting Member
1 Post |
 Posted - 2007-10-05 : 16:06:31
|
| I have an active/active setup with 3 groups. Two SQL Groups and one cluster group that also contains the DTC. I am 99% sure that I setup everything correctly and everything appears to be running fine. The issue is that in SQL Mgmt Studio, the instance that is running on the physical node that owns the Cluster group (therefor has the DTC) shows the Distributed Transaction Coordinator as online. The instance running on the other node show it as offline. Is this correct behavior? I am not a SQL Expert, and know enough to get things up and running and maintain them. Thanks in advance! |
|
|
eyechart
Master Smack Fu Yak Hacker
3575 Posts |
|
|
rmiao
Master Smack Fu Yak Hacker
7266 Posts |
Posted - 2007-10-05 : 23:17:29
|
| snivek, that's correct. Only instance that has same owner as dtc does will show running status. |
 |
|
|
|
|
|
DTC on Active/Active Cluster