BizTalk 2006 Tracking Database Won’t Shrink – Why

biztalkbiztalk-2006

I am running a BizTalk 2006 server instance on a SQL 2000 SP4 Database. I have a 10 GB Tracking DDB (9GB Used / 1GB Free). I am running the DTADB Archive & Purge jobs every hour. It is purging messages at 10 Days / 14 Days Hard. It runs without error. I take the purging down to 5 Days / 9 Days Hard and the Tracking Database's size only decreases by less than 5%.

Anybody have any thoughts or experience on what my be causing this issue?

Best Answer

I think it could be due to you using SQL server 2000.

The documentation for configuring purging of the database specifically states SQL Server 2005 and 2008.

http://msdn.microsoft.com/en-us/library/aa558715(BTS.10).aspx

There are also people who have had problems running purge scripts on SQL Server 2000.

http://www.biztalkgurus.com/forums/p/9443/18513.aspx

Hope this helps