Select the product you need help with
- Internet Explorer
- Windows Phone
- More products
Information about BizTalk hotfixes and Service Pack support
Article ID: 2003907 - View products that this article applies to.
When you install a Microsoft BizTalk server hotfix, consider the following variables:
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 both x86 and x64 downloads, make sure that you download the hotfix that corresponds to the bit specs of the BizTalk server in question.
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).
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.
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:
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:
To roll back a hotfix that includes an SQL script (.sql), follow these steps:
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 IndexFor 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
(http://go.microsoft.com/fwlink/?LinkId=151500)for other considerations.
Article ID: 2003907 - Last Review: December 9, 2011 - Revision: 23.0