MsgBoxDB

Home Page › Forums › BizTalk 2004 – BizTalk 2010 › MsgBoxDB

Viewing 1 reply thread
  • Author
    Posts
    • January 25, 2007 at 6:12 AM #17417
      community-content

        Hi,

        i've a problem with mgsboxdb. The transaction log of MsgBoxDB is increasing constantly.

        I used Sql Profiler but i don't see much. Now i've stopped provisioning server front-end and i detach db. i've create a new db msgbox but it is not the master. is it possible settings a new db such as master?

         thanks

      • January 25, 2007 at 7:39 AM #17419
        community-content

          To answer your original issue, you can stop MsgBox from growing in size by making sure that SQL cleanup jobs are running. The jobs are listed in biztalk documentation. Besides, if you have too many suspended messages, you may want clean them in HAT or use WMI scripts.

          • January 26, 2007 at 5:39 AM #17439
            community-content

              Hi,

              thank you for your answer. I'm using HAT for to terminate suspended messages but error is the follow:

              "One or more service instances could not be terminated. It is possible that the instance has already completed or terminated, or it may have a pending control message".

               

              For me is important to cleanup msgboxDB.

              Anyidea?

              • January 30, 2007 at 3:31 AM #17476
                community-content

                  OK, I resolved.

                   I'm using Biztalk 2004 Administration Tool.

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