Information about BizTalk hotfixes and Cumulative Update support

Article translations Article translations
Article ID: 2003907 - View products that this article applies to.
Expand all | Collapse all

Summary

When you install a Microsoft BizTalk server hotfix, Cumulative Update, or Service Pack consider the following variables:

  • x86 and x64 versions
  • Prerequisites
  • Restart requirements
  • Installing in a BizTalk group
  • Uninstall and rollback
  • Database backup

More Information

x86 and x64 versions

Some BizTalk files are compiled for 32-bit and for 64-bit individually. Other BizTalk files are compiled for both 32-bit and 64-bit, regardless of the CPU. When a BizTalk hotfix includes only an x86 download, the hotfix applies to both 32-bit and 64-bit BizTalk servers. When a BizTalk hotfix includes separate x86 and x64 downloads, make sure that you download the hotfix that corresponds to the bit specs of the BizTalk server in question.

Prerequisites

The user who installs the hotfix must be a Windows administrator on the BizTalk Server computer and a system administrator on the SQL Server computer.

Make sure that you back up all the BizTalk databases (for more information about how to do this, see "Backup the BizTalk Server databases" section).

Restart requirements

If the hotfix includes an SQL script (.sql), you must stop the BizTalk services and SQL Server Agent before you install the hotfix. After the hotfix installation is complete, restart the BizTalk services and the SQL Server Agent. If the hotfix does not include an SQL script (.sql), you must restart the BizTalk Host Instance after the hotfix installation is complete.

Note You can review the Setup.xml file to determine which files will be updated.

Install

When multiple BizTalk servers are configured in a group, you must install the hotfix on all BizTalk servers in the group. To do this, follow these steps:

  1. Stop all BizTalk host instances, custom isolated adapters, and any other services or applications (such as BizTalk Admin console, Health, and Activity Tracking) that are related to BizTalk services. Do this on all servers in the BizTalk group. If you use the HTTP, SOAP, WSE, or WCF adapters, restart and stop the IIS services. If you do not stop the IIS services you may still receive incoming traffic. This behavior may affect the update, and the traffic may be lost when you perform the rollback.

  2. Stop the SQL Server Agent service on the SQL instance(s) that host the BizTalk databases.

  3. Leave the SSO services running.

  4. Verify that the BizTalk databases are not in use by checking Activity Monitoring in SQL Server Management Studio or by running the sp_who2 SQL command.

  5. Install the hotfix on all servers in the BizTalk group. Only install the hotfix on one server at a time.

  6. Restart all the BizTalk services, all the IIS services, and the SQL Server Agent.

Uninstall and rollback

A BizTalk hotfix may update .dll files, and it may execute SQL scripts. If the hotfix contains only .dll files, and if it does not include an SQL script (.sql), it can be rolled back by using the uninstall command in Add or Remove Programs.  You can review the Setup.xml file to determine which files will be updated.

If the hotfix contains an SQL script (.sql), it will execute the SQL script against a BizTalk database or databases. In this case, the hotfix cannot be rolled back by uninstalling. If you uninstall by using Add or Remove Programs, this will not roll back the database changes, and it may leave the BizTalk environment in an inconsistent state.

Backup the BizTalk Server databases

Note Before you apply a hotfix that includes an SQL (.sql) script, you must back up all the BizTalk Server databases.

To force a full backup of the data and log files, execute the BizTalkMgmtDb.dbo.sp_ForceFullBackup stored procedure. Then, execute the Backup BizTalk Server SQL Agent job.

For more information about how to back up and restore the BizTalk Server databases in BizTalk Server, visit the following MSDN websites:

BizTalk Server 2010

BizTalk Server 2009

BizTalk Server 2006 R2 and BizTalk Server 2006

BizTalk Server 2004

To roll back a hotfix that includes an SQL script (.sql), follow these steps:

  1. Stop all BizTalk hosts, services, custom isolated adapters, and the SQL Server Agent. If you use the HTTP, SOAP, or WCF adapters, restart the IIS services. If you make heavy use of the isolated host, you may want to consider stopping the IIS services.
  2. Uninstall the hotfix by using Add or Remove Programs.
  3. Restore the full backups of all the BizTalk databases.

    Note You must back up and restore all the BizTalk databases.
  4. Restart all the BizTalk services and the SQL Server Agent.

    Note Do not execute any SQL scripts (.sql).

Service Pack and Cumulative Update Support

All service packs, cumulative updates, security updates and hot fixes are supported on a BizTalk Server. It is strongly encouraged to install the latest update for Windows, SQL Server, Visual Studio and any program installed. Service Packs for Microsoft products are supported based on the baseline support for that product. The Support Lifecycle Index lists the lifecycle information for BizTalk Server, SQL Server, Visual Studio and other Microsoft programs:

Support Lifecycle Index

For information on any minimum service pack requirements, refer to article 926628:

926628 Summary of 64-bit support, operating systems and SQL Server versions supported by BizTalk Server

Note This is a "FAST PUBLISH" article created directly from within the Microsoft support organization. The information contained herein is provided as-is in response to emerging issues. As a result of the speed in making it available, the materials may include typographical errors and may be revised at any time without notice. See Terms of Use for other considerations.

Properties

Article ID: 2003907 - Last Review: June 26, 2013 - Revision: 24.0
Applies to
  • Microsoft BizTalk Server Branch 2010
  • Microsoft BizTalk Server Developer 2010
  • Microsoft BizTalk Server Enterprise 2010
  • Microsoft BizTalk Server Standard 2010
  • Microsoft BizTalk Server 2009 Branch
  • Microsoft BizTalk Server 2009 Developer
  • Microsoft BizTalk Server 2009 Enterprise
  • Microsoft BizTalk Server 2006 R2 Branch Edition
  • Microsoft BizTalk Server 2006 R2 Developer Edition
  • Microsoft BizTalk Server 2006 R2 Standard Edition
  • Microsoft BizTalk Server 2006 R2 Enterprise Edition
  • Microsoft BizTalk Server 2006 Developer Edition
  • Microsoft BizTalk Server 2006 Standard Edition
  • Microsoft BizTalk Server 2006 Enterprise Edition
  • Microsoft BizTalk Server 2004 Partner Edition
  • Microsoft BizTalk Server 2004 Developer Edition
  • Microsoft BizTalk Server 2004 Standard Edition
  • Microsoft BizTalk Server 2004 Enterprise Edition
Keywords: 
KB2003907

Give Feedback

 

Contact us for more help

Contact us for more help
Connect with Answer Desk for expert help.
Get more support from smallbusiness.support.microsoft.com