When you install a Microsoft BizTalk server hotfix, Cumulative Update, or Service Pack consider the following variables:
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.
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:
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.
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:
To roll back a hotfix that includes an SQL script (.sql), follow these steps:
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