Cleanup your biztalk development database for a new project.

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)'

 

 

 

Tags: ,

Dev

BizTalk + AppFabric: An Introduction

by Paul 9. juni 2010 21:10

Tags:

Powered by BlogEngine.NET 1.5.0.7
Theme by Mads Kristensen