You must be logged on with an account that is a member of the SQL Server sysadmin fixed server role to perform this procedure.

1. Stop all BizTalk Server services. For more information, see How to Start, Stop, Pause, Resume, or Restart BizTalk Server Services.

2. Stop the IIS service.

3. Stop the SQL Server Agent service.

4. Follow the database backup procedures in SQL Server Books Online to back up the MessageBox database.

5. Follow the database restore procedures in SQL Server Books Online to restore the MessageBox database on the new server.

6. Use the Transfer Jobs task to copy the following SQL Server Agent jobs to the new SQL Server:

   • MessageBox_DeadProcesses_Cleanup_<BizTalkMsgBoxDb>
     
   • MessageBox_Message_Cleanup_<BizTalkMsgBoxDb>
     
   • MessageBox_Message_ManageRefCountLog_<BizTalkMsgBoxDb>
     
   • MessageBox_Parts_Cleanup_<BizTalkMsgBoxDb>
     
   • MessageBox_UpdateStats_<BizTalkMsgBoxDb>
     
   • Operations_OperateOnInstances_OnMaster_<BizTalkMsgBoxDb>
     
   • PurgeSubscriptionsJob_<BizTalkMsgBoxDb>
     
   • TrackedMessages_Copy_<BizTalkMsgBoxDb>
     

   For more information about using the Transfer Jobs task, see SQL Server Books Online.

7. Follow steps 6 through 12 in the procedure on how to restore the BizTalk Server databases. This procedure updates the BizTalk Management (BizTalkMgmtDb) database and registry with the new location of the MessageBox database. For more information, see How to Restore Your Databases.

   Note
   In the SampleUpdateInfo.xml file, comment out all of the databases except for the one you have moved to the new server.

Concepts