Home Page › Forums › BizTalk 2004 – BizTalk 2010 › Purge a very big Tracking database › Re: Purge a very big Tracking database
January 4, 2009 at 11:39 PM
#21468
Had your same situation and needed the DB clean last week. There is a stored proc in the DTA db named something along the lines of “purge all completed transactions”
I just run that as needed then shrink the log. Its a good way to clean the DB while still running in production when you dont have an option on taking your servers into maintenence.
Its relativly lightweight and although youll see it drop performance a bit, youll still be moving data at a good speed.