title: Purging Biztalk DTA Database
body: <p>Suddenly , We are receiving an Disk space alerts from  Production BizTalk 2010 database server . Alerts are set if 90% of disk space is full .   I have not noticed any slowness in BizTalk data processing  till now .  Below are points I have noticed :</p>
  
  <ol>
  <li><p>BizTalkDTADb size is ~ 65 GB ( Data file ~ 55 GB + log file ~ 10GB ) . All other database sizes are &lt; 2 GB .</p></li>
  <li><p>SQL Agent Job for purging and archiving DTA DB is not configured . </p></li>
  <li><p>BizTalk is running more than 3 years now. </p></li>
  <li><p>Global Tracking is on from Day 1 . </p></li>
  <li><p>I can see  orchestration Track Events checked in for orchestration tracking and can not find port level tracking checked in . </p></li>
  </ol>
  
  <p>Below are the action items i have planned till now based on my internet searches : </p>
  
  <ol>
  <li><p>Full Back up of BizTalk databases .</p></li>
  <li><p>Take BizTalk offline </p></li>
  <li><p>Purge BizTalkDTADb  (As we do not have any usage of tracking data) using Terminator Tool . </p></li>
  <li><p>Take BizTalk online again .</p></li>
  </ol>
  
  <p>I have below questions : </p>
  
  <ol>
  <li><p>I will be doing this for the first time , Could you please validate if I am going towards right direction  . </p></li>
  <li><p>What is the difference between running stored procedure run from SQL agent Job (dtasp_BackupAndPurgeTrackingDatabase) and running terminator tool  to purge DTA DB . Because I read online , that running SP(for full clean up )  might take days to execute because of current size . How much time should terminator tool take ? </p></li>
  <li><p><strong>I just installed Latest BizTalk terminator Tool v2.5.6.9 available  over internet . But I unable to find "Purge Everything in DTA" option as explained in <a href="https://blogs.msdn.microsoft.com/amantaras/2014/04/29/purging-trackingdta-db-using-terminator-tool/" rel="nofollow noreferrer">https://blogs.msdn.microsoft.com/amantaras/2014/04/29/purging-trackingdta-db-using-terminator-tool/</a> .
  What option I should go for clean up of DTA DB ?</strong> </p></li>
  </ol>
  
  <p>Please let me know if you need more information to answer . </p>
  
  <p>Regards,</p>
  
  <p>Goutamendu</p>