How to Clear or Purge the Biztalk Tracking Database
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.
declare @dtLastBackup datetime set @dtLastBackup = GetUTCDate() exec dtasp_PurgeTrackingDatabase 1, 0, 1, @dtLastBackup go DBCC SHRINKFILE (N'BizTalkDTADb' , 0) go DBCC SHRINKFILE (N'BizTalkDTADb_log' , 0) go DBCC SHRINKFILE (N'BizTalkDTADb' , TRUNCATEONLY) go DBCC SHRINKFILE (N'BizTalkDTADb_log' , TRUNCATEONLY) go
The last part shrinks the database and log files.