BizTalkMessageBox_Log is Crossing 80GB in Production Environment

Home Page › Forums › BizTalk 2004 – BizTalk 2010 › BizTalkMessageBox_Log is Crossing 80GB in Production Environment

Viewing 1 reply thread
  • Author
    Posts
    • November 8, 2012 at 8:21 PM #25907
      community-content

        Hi All

        I want to shrink the BizTalkMessageBox_Log as an immediate effect. Please advice.

        Thanks,

        KP

      • November 9, 2012 at 1:19 AM #25908
        community-content

          Have you tried running messagebox viewer for suggestions?

          Maybe you can use terminator tool?

          • November 9, 2012 at 3:12 AM #25909
            community-content

              Hi Thanks for your response, can you please elaborate?

              • November 9, 2012 at 3:35 AM #25910
                community-content

                  Hi,

                  Can you check if the BizTalk backup job runs fine? This is a typical example where the BizTalk backup job is not configurered and the log file keeps on growing.

                  Is the job configured? For more information, see:

                  msdn.microsoft.com/…/aa546765%28v=bts.20%29.aspx

                  If you have any problems configuring the job, just shout 🙂

                  Regards

                  • November 18, 2012 at 8:10 AM #25914
                    community-content

                      Hi, Thanks again for your kind response, I verified backup job is configured correctly. If I shrink the BizTalkMsgBox_Log database to some 10GB or 15GB. Is that ok?

                      • November 18, 2012 at 8:48 AM #25915
                        community-content

                          Hi,

                          When the log file is extremely large, then this is signal that something is wrong with your biztalk (sql) servers and you should investigate this. When time is not your friend, you could shrink the log file by using the following command. Make sure that you have stopped the host instances and the sql server agent!

                          sp_helpdb ’BizTalkMsgBoxDb’

                          ALTER DATABASE BiztalkMsgBoxDb

                          SET RECOVERY SIMPLE;

                          GO

                          DBCC SHRINKFILE (BiztalkMsgBoxDb_log, 1);

                          GO

                          sp_helpdb ’BizTalkMsgBoxDb’

                          GO

                          ALTER DATABASE BiztalkMsgBoxDb

                          SET RECOVERY FULL

                          GO

              • Author
                Posts
              Viewing 1 reply thread
              • The forum ‘BizTalk 2004 – BizTalk 2010’ is closed to new topics and replies.