Friday, July 16, 2010

Isolated Host Instance Active Messages

Sometimes it has happened that our BizTalk 2006 R2 development and test servers end up with many active instances running on the Isolated Host Instance.

We can't terminate these instances using the administration console.

I found this solution on the web, using a database stored procedure (bts_CleanupMsgBox) that needs to be created first using a DB Schema file that's installed with BizTalk Server.

Don't forget to run this SP using "exec bts_CleanupMsgBox" instead of the "Execute" command from SQL Server Management Studio!!

PS: Always backup you databases before running bts_CleanupMsgBox!