[BTS] Clear BizTalkMsgBoxDb (2)

Source: Internet
Author: User
Tags biztalk

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

Contact Us

The content source of this page is from Internet, which doesn't represent Alibaba Cloud's opinion; products and services mentioned on that page don't have any relationship with Alibaba Cloud. If the content of the page makes you feel confusing, please write us an email, we will handle the problem within 5 days after receiving your email.

If you find any instances of plagiarism from the community, please send an email to: info-contact@alibabacloud.com and provide relevant evidence. A staff member will contact you within 5 working days.

A Free Trial That Lets You Build Big!

Start building with 50+ products and up to 12 months usage for Elastic Compute Service

  • Sales Support

    1 on 1 presale consultation

  • After-Sales Support

    24/7 Technical Support 6 Free Tickets per Quarter Faster Response

  • Alibaba Cloud offers highly flexible support services tailored to meet your exact needs.