BizTalk provides an out of the box job that can be configured to archive and purge BizTalk databases. But sometimes you might be in a situation where archival not necessary and you might as well save that time and simply purge the tracking data.

If you want to do that, here is a quick tip –

• Open the SQL Management Studio, connect to the BizTalk tracking database server
• Run the following sproc on the DTADB - dtasp_PurgeAllCompletedTrackingData

This stored procedure takes care of purging all the data without archiving. This link (http://msdn.microsoft.com/en-us/library/dd745781.aspx) will provide further details for BizTalk 2006 R2.

It's very handy when cleaning off the database for production go-live after performing a quick smoke test.

--Sanket