Dear All,

I have a question regarding the suspended messages. In fact in our
integration server we have suspended messages dating from the begining
2004 (begining of the project). These suspended messages info are
useless especially now (we have more than 400 000 suspended messages).

Is there a way to kill all these messages and get rid of them in the
Database at once? Using the HAT is fastidious and not very practicle
especially in deleting all the 400 000 suspended messages.

My last desperate action would be to truncate the following tables in
the BizTalkMsgBoxDb, is it recomanded? is there a MS Script that does
this?

BizTalkServerApplicationQ_Suspended
Instaces
messageparts
messagerefcountlogtotals
partrefcountlogtotals
parts
spool

Any help would be greatly appreciated...

Thanks,
Stefan

[ Post a follow-up to this message ]

In BizTalk Server 2006, it's much easier to do this type of operation
through UI with the Admin MMC.  There is much better support for bulk
terminates and bulk resumes, grouped by selective qualifiers.

In BTS 2004, you can terminate suspended instances using some WMI calls.
There is a "Terminate Instances" code sample on the following site designed
for BTS 2006, but it can probably be adapted to BTS 2004 with little to no
work:
http://www.gotdotnet.com/codegaller...616f-838c-4583-
a4c5-cecc5ac04dac

HTH,
Doug Girard [MSFT]

Note: This posting is provided "AS IS" with no warranties, and confers no
rights.
--------------------
>From: "Stefan" <maltistefan@yahoo.co.nz>
>Newsgroups: microsoft.public.biztalk.general
>Subject: BTS 2004 : How to terminate ALL suspended messaging /
Orchestrations
>Date: 14 Apr 2006 04:17:57 -0700
>Organization: http://groups.google.com
>Lines: 28
>Message-ID: <1145013476.963334.33920@z34g2000cwc.googlegroups.com>
>NNTP-Posting-Host: 194.3.231.254
>Mime-Version: 1.0
>Content-Type: text/plain; charset="iso-8859-1"
>X-Trace: posting.google.com 1145013488 29433 127.0.0.1 (14 Apr 2006
11:18:08 GMT)
>X-Complaints-To: groups-abuse@google.com
>NNTP-Posting-Date: Fri, 14 Apr 2006 11:18:08 +0000 (UTC)
>User-Agent: G2/0.2
>X-HTTP-UserAgent: Mozilla/5.0 (Windows; U; Windows NT 5.1; fr; rv:1.8.0.1)
Gecko/20060111 Firefox/1.5.0.1,gzip(gfe),gzip(gfe)
>Complaints-To: groups-abuse@google.com
>Injection-Info: z34g2000cwc.googlegroups.com; posting-host=194.3.231.254;
>   posting-account=DyNGog0AAACfz2qW1Zwnq-93sNuzukww
>Path:
TK2MSFTNGXA01.phx.gbl!TK2MSFTNGP01.phx.gbl!TK2MSFTFEEDS01.phx.gbl!msrtrans!n
ewsfeed.media.kyoto-u.ac.jp!newsfeed.icl.net!newsfeed.fjserv.net!oleane.net!
oleane!nerim.net!proxad.net!216.239.36.134.MISMATCH!postnews.google.com!z34g
2000cwc.googlegroups.com!not-for-mail
>Xref: TK2MSFTNGXA01.phx.gbl microsoft.public.biztalk.general:36645
>X-Tomcat-NG: microsoft.public.biztalk.general
>
>Dear All,
>
>I have a question regarding the suspended messages. In fact in our
>integration server we have suspended messages dating from the begining
>2004 (begining of the project). These suspended messages info are
>useless especially now (we have more than 400 000 suspended messages).
>
>Is there a way to kill all these messages and get rid of them in the
>Database at once? Using the HAT is fastidious and not very practicle
>especially in deleting all the 400 000 suspended messages.
>
>My last desperate action would be to truncate the following tables in
>the BizTalkMsgBoxDb, is it recomanded? is there a MS Script that does
>this?
>
>BizTalkServerApplicationQ_Suspended
>Instaces
>messageparts
>messagerefcountlogtotals
>partrefcountlogtotals
>parts
>spool
>
>Any help would be greatly appreciated...
>
>Thanks,
>Stefan
>
>

[ Post a follow-up to this message ]