FW:Clean up your BizTalk databases

最新推荐文章于 2025-09-11 20:53:34 发布

weixin_30788731

最新推荐文章于 2025-09-11 20:53:34 发布

阅读量73

点赞数

CC 4.0 BY-SA版权

文章标签：数据库

原文链接：http://www.cnblogs.com/upzone/archive/2007/04/09/705600.html

本文提供了一套用于BizTalk MessageBox和Tracking数据库清理的脚本及步骤。首先通过创建并执行bts_CleanupMsgBox存储过程来清理MessageBox数据库，然后执行bts_PurgeSubscriptions存储过程。对于跟踪数据，则通过dtasp_CleanHMData存储过程进行清理。

Here are a few scripts / stored procedures that most of the BizTalk newbies would love to know.

These scripts are very useful in a development environment to clean up your MessageBox and Tracking databases.

To clean up the MessageBox

First create the stored procedure bts_CleanupMsgBox by running the sql script found in <BizTalk Installation Folder>\Schema\msgbox_cleanup_logic.sql against your MessageBox database(BizTalkMsgBoxDb).
- Note that your BizTalkMsgBoxDb database will already have a dummy stored procedure by the same name which does nothing, so it is important that you run the above script if this is your first time.
Stop all BizTalk services.
Reset IIS server (run iisreset from start/run) if you are running any webservices
Execute stored procedure bts_CleanupMsgbox on your message box database
Execute stored procedure bts_PurgeSubscriptions on your message box database
Restart all BizTalk services

To clean up the Tracking data