using msgbox_cleanup_logic.sql in production

Home Page › Forums › BizTalk 2004 – BizTalk 2010 › using msgbox_cleanup_logic.sql in production

Viewing 1 reply thread
  • Author
    Posts
    • #16139

      hi,

      I need to run the [dbo].[bts_CleanupMsgbox] procedure in production environment, the msgbox_db has more than 500000 suspended instances…. is there any restriction or any special warning?  

      regards!

    • #19376

      hi there, i’m not a biztalk guru, but i just found this warning.

      Manually purging the BizTalk MessageBox database in a production environment is not supported.

      http://msdn2.microsoft.com/en-us/library/bb727781.aspx

      • #19383

        Carlos,

        I’ll second the above comment – there are many warnings about using this in a production environment. If Microsoft say don’t, I think its fair to say that you shouldn’t!!

        I’m in a similar situation with a large number of suspended instances (20 million+) and we are using a custom WMI script to clear these messages down. Its taking a while, but its getting the job done.

        If you can advise what type of messages are suspended, I’ll modify our WMI script for you to use.

        Regards, Nick.

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