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.