Truncate BizTalk MsgBox Log

[Sudhir]

We are using BizTalk 2006 Server and are using BizTalk databases in full
recovery model.

Our MsgBox log has increased a lot (currently it's size is 110 GB) and is
not getting truncated. BizTalk backup job is working successfully but is
still not truncating MsgBox log.

We even tried truncating manually but then it clashes with backup job and
breaks log backup chain and then backup job start fresh and triggers full
backup followed again by log backups.

Our MsgBox DB size is 113 GB out of which 110 GB is log size.

Please advice.

Regards,
Sudhir

[Armen Kirakosyan]

Hi

try to create new MessageBox database
Then shange in SQL from "FULL" to "SIMPLE"
then manualy truncate, should work

There should be a tool from BizTalk console to manage the size of MessageBox
but.....
--
MCPD, MCT
http:/www.explorer.am - Explore Armenia!

Post by Sudhir
We are using BizTalk 2006 Server and are using BizTalk databases in full
recovery model.
Our MsgBox log has increased a lot (currently it's size is 110 GB) and is
not getting truncated. BizTalk backup job is working successfully but is
still not truncating MsgBox log.
We even tried truncating manually but then it clashes with backup job and
breaks log backup chain and then backup job start fresh and triggers full
backup followed again by log backups.
Our MsgBox DB size is 113 GB out of which 110 GB is log size.
Please advice.
Regards,
Sudhir

[Sudhir]

Hi Armen,

Thanks for the reply but we found the cause and solution.

log_reuse_wait and log_reuse_wait_desc columns in sys.databases view to find
out what's stopping log to be truncated. We found that there is some long
running transaction on MessageBox, and databases got truncated once that job
was killed.

Thanks,
Sudhir

Post by Armen Kirakosyan
Hi
try to create new MessageBox database
Then shange in SQL from "FULL" to "SIMPLE"
then manualy truncate, should work
There should be a tool from BizTalk console to manage the size of MessageBox
but.....
--
MCPD, MCT
http:/www.explorer.am - Explore Armenia!

Post by Sudhir
We are using BizTalk 2006 Server and are using BizTalk databases in full
recovery model.
Our MsgBox log has increased a lot (currently it's size is 110 GB) and is
not getting truncated. BizTalk backup job is working successfully but is
still not truncating MsgBox log.
We even tried truncating manually but then it clashes with backup job and
breaks log backup chain and then backup job start fresh and triggers full
backup followed again by log backups.
Our MsgBox DB size is 113 GB out of which 110 GB is log size.
Please advice.
Regards,
Sudhir