Clean up your BizTalk databases

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

1.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.
2.Stop all BizTalk services.
3.Reset IIS server (run iisreset from start/run) if you are running any webservices
4.Execute stored procedure bts_CleanupMsgbox on your message box database
5.Execute stored procedure bts_PurgeSubscriptions on your message box database
6.Restart all BizTalk services

To clean up the Tracking data

1.Stop all BizTalk services.
2.Execute stored procedure dtasp_CleanHMData on your tracking database (BizTalkDTADb)
3.Restart all BizTalk services

from:http://geekswithblogs.net/benny/archive/2007/03/28/110122.aspx