Stop all running Biztalk services, load up SQL Management Studio, on the BiztalkDTADb database run the following script. Note that this script does not archive data. After this has completed you can shrink the database files.
How to Clear or Purge the Biztalk Message Box Database
If the BizTalk message box database, by default BizTalkMsgDb, or the log file for that matter, gets too large, performance of the database subsystem will be affected considerably. If your message box has grown too large and Biztalk becomes unresponsive, you might want to clean up the database manually, to do so check this link. … Continue reading How to Clear or Purge the Biztalk Message Box Database
Sharepoint/MOSS Deployment, Installation Links
How to install SharePoint Server 2007 on a single machine Creating New MOSS 2007 Task Using BizTalk WSS Adapter (how to configure the Biztalk WSS Adaptor) Deploy in a Simple Server Farm (Office Sharepoint Server)