Geeks With Blogs

Connected Systems Chilled Out Blog Hanging stuff together in a meaningful way with some fun added

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 Posted on Wednesday, March 28, 2007 1:49 PM | Back to top

Comments on this post: Huge BizTalk Transaction Log Issue

No comments posted yet.
Your comment:
 (will show your gravatar)

Copyright © BizTalk Visionary | Powered by: