Reputation
Top tag
Next privilege 200 Rep.
See reduced ads
Badges
1
Newest
 Teacher
Impact
~224 people reached

  • 0 posts edited
  • 0 helpful flags
  • 0 votes cast
Nov
21
awarded  Teacher
Oct
18
comment Windows Cluster - Can I failover without disturbing SQL?
MSDTC can also fail over without affecting SQL Server instances as it has its own IP, etc. Even if you are using distributed transactions, a distributed tran in progress would roll back upon failover. Most SQL installations to my knowledge do not use MSDTC, and it is just there as a default or to support SSIS.
Oct
14
answered Windows Cluster - Can I failover without disturbing SQL?
Mar
31
answered Will a SQL Server Replication Reinitialization overwrite data?
Mar
31
answered Diagnosing SQL Server 2008 Timeout After Prolonged Use
Mar
31
answered Access rights with Views