Select the product you need help with

Information about BizTalk hotfixes and Service Pack support

Article ID: 2003907 - View products that this article applies to.

Expand all | Collapse all

Summary

When you install a Microsoft BizTalk server hotfix, consider the following variables:

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

Back to the top | Give Feedback

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 both 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:

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.
Stop the SQL Server Agent service on the SQL instance(s) that host the BizTalk databases.
Leave the SSO services running.
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.
Install the hotfix on all servers in the BizTalk group. Only install the hotfix on one server at a time.
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.

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:

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.
Uninstall the hotfix by using Add or Remove Programs.
Restore the full backups of all the BizTalk databases.

Note You must back up and restore all the BizTalk databases.
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

Back to the top | Give Feedback

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

(http://go.microsoft.com/fwlink/?LinkId=151500)

for other considerations.

Back to the top | Give Feedback