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)"
Subscribe to:
Post Comments (Atom)
2 comments:
That was a great help - thanks. Hope you don't mind but published info on our blog site with a reference back to yourself!
Fine by me :-)
Post a Comment