No matter which version of BizTalk Server is used, you will find that the database becomes very large. In fact, BizTalk has provided several small scripts to handle this problem. These scripts should be mastered by new users.
These scripts are used to process the MessageBox and Tracking databases. It is generally not recommended to use them on PRD unless you have.
Clear MessagbeBox
You can find a Script named msgbox_cleanup_logic. SQL under <BizTalk Installation Folder> \ Schema \. It is specially used to process MessageBox data and you need to execute it once, update the actual content of the SP to the DB, because the DB only defines an empty shell with no meat.
Operation Process: Stop all BizTalk host implementations, restart IIS, execute bts_cleanupMsgBox, and execute bts_PurgeSubscriptions.
Clear Tracking Data
Step 1: Stop all BizTalk host instances and run dtasp_CleanHMData.
We recommend that you perform the preceding operations only on DEV.
Xuzhong
Beijing titanu chengze Network Communication Technology Co., Ltd.
Www.51biztalk.com