Share via

BizTalk and Database Mirror: Supported or Not?

  • Article

Lots of BizTalk developers and architects have been looking at the SQL Server 2005 database mirror option and are wondering if they can use this to implement a low cost disaster recovery solution for their BTS environments.  It certainly is a tempting solution and it sure seems to be viable from technical point of view. Unfortunetly, our product team has stated that this is NOT a supported configuration. The reason for this is that there are key issues surrounding DTC and SQL Server before this configuraion will be viable in production systems.   We've seen some clients try and implement this on their own and they have encountered issues around BizTalk continuing to look for the primary server after the failover has occured.

Personally, I'm hoping we might see these issues worked out in time for the R2 release, however that is just my own personal hope and can't be taken as an official timeline in any way.

Cheers and keep on BizTalking

Comments