by Paul
13. augustus 2010 07:35
To clean up the MessageBox
- Stop all BizTalk services.
- Reset IIS server (run iisreset from start/run) if you are running any webservices
- Execute stored procedure bts_CleanupMsgbox on your message box database
- Execute stored procedure bts_PurgeSubscriptions on your message box database
- Restart all BizTalk services
To clean up the Tracking data
- Stop all BizTalk services.
- Execute stored procedure dtasp_CleanHMData on your tracking database (BizTalkDTADb)
- Restart all BizTalk services
Finally shrink all databases:
EXEC sp_MSForEachDB 'DBCC SHRINKDATABASE (''?'' , 0)'
by Paul
9. juni 2010 21:10
07c1e0a1-ca26-4399-aaab-32f9670642cd|0|.0
Tags: biztalk