Biztalk2004 SQL 2000 Database maintenance BizTalkMsgBoxDB
I have been running biztalk for just over a year now, and thing have been working well. The issue I am having is that the BizTalkMsgBoxDB is getting HUGE. it is currently 30GB. Is there a way that I can safely archive some of the data in this table?
ASKER
All of the above jobs are present and running.
BizTalkMsgBoxDB is 30GB (27GB Used)
BizTalkMsgBoxDB _log is 9GB (4GB) used
BizTalkMsgBoxDB is 30GB (27GB Used)
BizTalkMsgBoxDB _log is 9GB (4GB) used
ASKER
I looked at the logs for the individual jobs and they are running every 1 minute and take no time to complete (<1sec), but I do not see that they are deleting anything.
is there something that needs to be defined on the orchestration to tell it to be pureable?
is there something that needs to be defined on the orchestration to tell it to be pureable?
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER
This got me on the right track. The actual table that is bloated is tracking_spool1 in my BiztalkMsgBoxDb.
here is what is recommended per Microsoft: http://support.microsoft.com/?id=907661
here is what is recommended per Microsoft: http://support.microsoft.com/?id=907661
If the message box is growing continuously it probably is not related to tracked messages. It is most likely that the TrackingSpool_Cleanup_BizT
such us:
MessageBox_Message_Cleanup
MessageBox_Parts_Cleanup_B
CleanupBTFExpiredEntriesJo
PurgeSubscriptionsJob_BizT
TrackingSpool_Cleanup_BizT
MessageBox_DeadProcesses_C
-------------
what sql agent jobs do you see?
BTW: what the BizTalkMsgBoxDB db files sizes:
Maybe it is time to shrink trans log file of the BizTalkMsgBoxDB ?