Export (0) Print
Expand All

Use of SQL Server database mirroring or the Volume Shadow Copy service

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.

See Also

© 2010 Microsoft Corporation. All rights reserved.

Community Additions

ADD
Show:
© 2014 Microsoft