|
Home > Archive > BizTalk Server > February 2005 > How do you clean up the BizTalk Message Box?
You are viewing an archived Text-only version of the thread.
To view this thread in it's original format and/or if you want to reply to
this thread please [click here]
| Author |
How do you clean up the BizTalk Message Box?
|
|
| Tudor Saru 2005-02-03, 5:49 pm |
| Our BizTalk Message Box is excessively large... How do I clean up the
database of the old archived messages or other unnecessary messages? Is there
a way to selfpurge the messagebox? Is there a way to set a limit to the size
of the message box so that it selfpurges at some point when it reaches a
certain size?
Many thanks in advance,
Tudor
| |
| Matt Milner 2005-02-04, 2:47 am |
| Check that SQL Server agent is running and that your purge jobs have
completed. There are also some scripts in the sdk for purging the tracking
database.
Matt
"Tudor Saru" <TudorSaru@discussions.microsoft.com> wrote in message
news:67B8817D-79E4-460C-99E7-6035D1312334@microsoft.com...
> Our BizTalk Message Box is excessively large... How do I clean up the
> database of the old archived messages or other unnecessary messages? Is
> there
> a way to selfpurge the messagebox? Is there a way to set a limit to the
> size
> of the message box so that it selfpurges at some point when it reaches a
> certain size?
>
> Many thanks in advance,
> Tudor
| |
| chasmcg@aol.com 2005-02-07, 5:54 pm |
| I found this I hope it helps you too:
http://biztalkers.blogspot.com/2005...s-guide-to.html
In the Guide under: BizTalk Development:Quick BizTalk Gotchas it talks
about MS SDK - Prune Database
****************************************
*
We we first started volume testing BizTalk, we easily maxed out the
Message Box and Tracking Databases. When these guys fill up, all hell
breaks loose!! Make sure that you have space available and be sure and
use the PruneDatabase stored procedure that is provided in the SDK. I
think this sample is not included in the original install of BizTalk,
but the additional SDK's that were released with Rollup 1. I'm still
not sure why this Prune job takes so long to run!
****************************************
***
Matt Milner wrote:
> Check that SQL Server agent is running and that your purge jobs have
> completed. There are also some scripts in the sdk for purging the
tracking[vbcol=seagreen]
> database.
>
> Matt
>
>
> "Tudor Saru" <TudorSaru@discussions.microsoft.com> wrote in message
> news:67B8817D-79E4-460C-99E7-6035D1312334@microsoft.com...
the[vbcol=seagreen]
messages? Is[vbcol=seagreen]
the[vbcol=seagreen]
reaches a[vbcol=seagreen]
|
|
|
|
|