Clean up your BizTalk databases

BizTalk清理脚本

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

转载最新推荐文章于 2025-09-11 20:53:34 发布 · 47 阅读

CC 4.0 BY-SA版权

原文链接：http://www.cnblogs.com/neozhu/archive/2007/04/05/700766.html

文章标签：

本文提供了一些对于BizTalk新手非常有用的脚本和存储过程，这些工具可以帮助开发者在开发环境中清理MessageBox和Tracking数据库。

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