126 reputation
1
bio website
location
age
visits member for 3 years, 8 months
seen Jun 24 at 17:25

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