Manually purge DTA

Hi everyone, on development and validation server, I frequently got space disk issue due to DTA log size.

So, if your developpers don’t want to configure all biztalk jobs, or you forget to configure those job on validation stage please follow the next instructions :

  • Stop all BizTalk Host Instance
  • Stop IIS Server
  • Stop SSO service
  • Connect to BizTalk SQL server with SQL Server Management Studio (Run ssms)
  • In Object explorer go to BizTalkDtaDb
  • Execute Stored procedure dtasp_PurgeAllCompletedTrackingData
  • After execution, I recommend to shrink the database
  • Now check the Database size, and you’ll see that it’s empty 🙂

 

For more information please go on http://msdn.microsoft.com/en-us/library/aa561918.aspx