Take the 2-minute tour ×
Server Fault is a question and answer site for professional system and network administrators. It's 100% free, no registration required.

We had an interesting scenario in our clustered production environment last week. SQL 2008/R2 two boxes clustered on Win 2008/R2 in Active/Passive mode. On the active node A, the clustered MS/DTC service lost connection the SAN (but other drives didn't), and thus failed over to node B. The SQL kept running on Node A.

We have BizTalk server on another machine, talking to that SQL, and BizTalk requires DTC. So although our web apps kept working with SQL, BizTalk was failing.

The question: Is it possible to make SQL also failover to B if any of its resources (such as MSDTC) fails.

share|improve this question

Your Answer

 
discard

By posting your answer, you agree to the privacy policy and terms of service.

Browse other questions tagged or ask your own question.