Quick Tips: DTA DB Purge without Archiving


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


Skip to main content