Had a problem in house with a huge transaction log...thanks to Heidman at BizTalk Tips we were able to solve it. he posted:
I had some problems with a huge transaction log on BizTalkMsgBoxDb – 32 Gb !
Backup was taken directly of the data files, but even if I created a transaction log backup of the database, the file kept growing, The problem was that BizTalk never stopped using the database, sow there was no space to shrink the base after the backup.
The solution was to change the backup job. I added a new step after the backup step: “DBCC SHRINKFILE (BizTalkMsgBoxDb_log, 0)"
That really worked for us!!
Previously posted at blog.Solidsoft.com