To clean up the MessageBox

• First create the stored procedure bts_CleanupMsgBox by running the sql script found in <BizTalk Installation Folder>\Schema\msgbox_cleanup_logic.sql against your MessageBox database(BizTalkMsgBoxDb).
  • Note that your BizTalkMsgBoxDb database will already have a dummy stored procedure by the same name which does nothing, so it is important that you run the above script if this is your first time.
• 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

Pessoal, importante testar esses procedimentos em ambiente controlado primeiro (ambiente de testes), e cuidado ao limpar as bases ;)

Grande Abraço,

Douglas Mello.