|
Home > Archive > BizTalk Server General > February 2005 > How can I clean out my BizTalkMsgBoxDb
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 can I clean out my BizTalkMsgBoxDb
|
|
| Anthony Morgan 2005-02-01, 5:59 pm |
| Hello
I'm running into a problem on my production biztalk box. My
BizTalkMsgBoxDb is getting very large. It is currently 16gig with a
12gig log file.
I have more dick space on the way, but I need some more space quick.
Does anybody know how to purge data from this table?, or is it even
save to purge just the log file?
I process a lot of very large datasets, but no long running
transactions, so any message archived in here are not needed.
I found the sample to purge the tracking database, but that DB is only
56meg. The message database is my problem.
Can anybody help?
Thanks
Anthony
| |
| Alan Smith 2005-02-02, 7:47 am |
| Hi Anthony,
The SQL Server should ahve a task set up to transfer the message tracking
information from the message box database to the tracing database. The MBDB
size should not grow to large, it's the tracking DB that increaces over time.
Check that SQL Server Agent is running, and check that the BizTalk jobs are
running as they should. You should also make sure the "Backup BizTalk" server
job has been setup, and is running OK.
Regards,
Alan
"Anthony Morgan" wrote:
> Hello
>
> I'm running into a problem on my production biztalk box. My
> BizTalkMsgBoxDb is getting very large. It is currently 16gig with a
> 12gig log file.
>
> I have more dick space on the way, but I need some more space quick.
> Does anybody know how to purge data from this table?, or is it even
> save to purge just the log file?
>
> I process a lot of very large datasets, but no long running
> transactions, so any message archived in here are not needed.
>
> I found the sample to purge the tracking database, but that DB is only
> 56meg. The message database is my problem.
>
> Can anybody help?
>
> Thanks
> Anthony
>
| |
| Niklas E 2005-02-10, 5:52 pm |
| Look in the HAT if there are any erronous messages in there waiting to be
deleted or to be re-submitted. You should back up your log as well and RAR
it, move it somewhere else.
If you don't really care about history, are able to re-submit without
problems or so, e.g. in a test environment, you can try this SQL Script,
which deletes the tracking Db content and deletes the log files and shrinks
the Databases. You have been warned. Do not try this at home ;) :
USE BizTalkDTADb
DECLARE @Today datetime
SET @Today = GETDATE()
EXEC dtasp_PruneTrackingDatabase @Today
backup log BizTalkDTADb with truncate_only
backup log BizTalkMgmtDb with truncate_only
backup log BizTalkMsgBoxDb with truncate_only
backup log BizTalkHwsDb with truncate_only
backup log SSODB with truncate_only
backup log TempDB with truncate_only
DBCC SHRINKDATABASE (BizTalkDTADb,0)
DBCC SHRINKDATABASE (BizTalkMgmtDb,0)
DBCC SHRINKDATABASE (BizTalkMsgBoxDb,0)
DBCC SHRINKDATABASE (BizTalkHwsDb,0)
DBCC SHRINKDATABASE (SSODB,0)
DBCC SHRINKDATABASE (TempDB,0)
Best regards
Niklas Engfelt
"Anthony Morgan" <Anthony Morgan@discussions.microsoft.com> wrote in message
news:c8vvv0tj1ggsbp9eajpon7irba9ompb0tl@
4ax.com...
> Hello
>
> I'm running into a problem on my production biztalk box. My
> BizTalkMsgBoxDb is getting very large. It is currently 16gig with a
> 12gig log file.
>
> I have more dick space on the way, but I need some more space quick.
> Does anybody know how to purge data from this table?, or is it even
> save to purge just the log file?
>
> I process a lot of very large datasets, but no long running
> transactions, so any message archived in here are not needed.
>
> I found the sample to purge the tracking database, but that DB is only
> 56meg. The message database is my problem.
>
> Can anybody help?
>
> Thanks
> Anthony
|
|
|
|
|