Message Box cleanup

It is usually a very important task to clean up a BizTalk mseeage box during stress testing with large amount of messages. Below are the steps to clean up the message box in order to prepare for the new test.

1. Stop all BizTalk services

2. Type iisreset at command line to recycle IIS service

3. Execute the stored procedure bts_CleanupMsgbox on your message box database

4. Execute the stroed procedure bts_PurgeSubscriptions on your message box database

(if the above stored procedures can't be found, go to your BizTalk installation directory, under “Schema” folder, you can find all original scripts of these stored procedures)

5. Clean up the message box log by running the backup statement similar to below

backup log msgBoxDb to disk = 'yourbackupdirectory\yourbackupfile.bak' with init, stats = 5

6. Restart BizTalk services

Comments

Anonymous said…
Woah! I'm really loving the template/theme of this website.

It's simple, yet effective. A lot of times it's hard to get that "perfect balance"
between superb usability and appearance. I must say that you've done a
great job with this. In addition, the blog loads very fast for me on Internet explorer.
Outstanding Blog!

my weblog; garcinia cambogia with 60 hca
Anonymous said…
Very good website you have here but I was curious about if you knew of any community forums
that cover the same topics discussed here? I'd really like to be a part of online community where I can get feed-back from
other knowledgeable individuals that share the same interest.
If you have any suggestions, please let me know. Appreciate it!


Have a look at my site; good heart foods
Hi
You can easily find communities in MSDN forums

Popular posts from this blog

How to poll database using WCF-SQL adapter

SQL query timeout from application but works fast from SSMS