Export (0) Print
Expand All

SQL Server database mirroring, Volume Shadow Copy service and AlwaysOn

[Unless specifically noted, the content in this topic applies to BizTalk Server 2013 and 2013 R2.]

Microsoft provides software solutions known as SQL Server database mirroring and the Windows Volume Shadow Copy Service (VSS) to increase high availability for particular scenarios. SQL Server database mirroring increases the probability that a database is available while the Volume Shadow Copy Service (VSS) provides backup and restore functionality for disaster recovery. The use of SQL Server database mirroring or the Windows Volume Shadow Copy Service are not supported solutions for ensuring high availability of Microsoft BizTalk Server databases.

Using SQL Server database mirroring to provide high availability for BizTalk Server databases

The use of SQL Server database mirroring is not currently a supported solution for ensuring high availability of the Microsoft BizTalk Server databases because of potential problems maintaining transactional consistency in the BizTalk Server databases. For more information about Database Mirroring and Cross-Database Transactions in SQL Server see http://go.microsoft.com/fwlink/?LinkId=87977. BizTalk Server databases should be installed on a SQL Server cluster to ensure high availability and BizTalk log shipping should be utilized for purposes of disaster recovery. For more information about BizTalk log shipping, see Log Shipping.

Using the Volume Shadow Copy service to provide high availability for BizTalk Server databases

The Volume Shadow Copy Service provides backup and restore functionality for disaster recovery. Because Microsoft Distributed Transaction Coordinator (MS DTC) support for VSS it is limited to local deployment and transaction coordination scenarios (and also subject to other limitations), use of the VSS service is not currently a supported solution for ensuring high availability of the Microsoft BizTalk Server databases. For more information about Volume Shadow Copy Service Support with Distributed Transactions see http://go.microsoft.com/fwlink/?LinkId=139505.

Using SQL Server AlwaysOn

When BizTalk Server and SQL Server are installed on separate computers, Distributed Transaction Coordinator (MS DTC) handles the transactions between the computers. As a result, the SQL Server AlwaysOn feature is not supported. The SQL Server AlwaysOn feature does not support MSDTC transactions.

See Also

© 2014 Microsoft Corporation. All rights reserved.

Community Additions

ADD
Show:
© 2015 Microsoft