If you’ve wanted a way to get your MessageBox’s back to it’s install state – brand new freshly ‘shrink wrapped’
Here’s the big Burtha of techniques – it goes without saying This will DESTROY
all existing MessageBox DATA in one swoop!
Great for testing purposes though 🙂
Grab msgbox_cleanup_logic.sql found
in ..\Microsoft BizTalk Server 2006\Schema
Run that in SQL Query Analyser. (or
SQL Management Studio)
run Exec bts_CleanupMsgbox
Viola! (and hope you didnt run it on the wrong machine 🙂
You’d still need to look after the other databases such as Tracking etc.