Cleanup BizTalk Servers MgmtDb

Listen with webReader
Published 24 February 09 09:27 PM | Johan Hedberg

I've previously blogged about cleaning (emptying) the MsgBox database, something that can be useful in some scenarios, like development and test. While looking for something else the other day I found information about an equally useful procedure, again mainly in an development environment. Speaking for myself I can say that there has been a number of time where I have just wanted to start from a clean slate with my development BizTalk Server installation. Just remove all ports and other deployed artifacts and start from a clean slate. Do NOT run this in production, and be careful that this is REALLY what you want even when running it in another environment.

According to the documentation:
In the BizTalk Management (BizTalkMgmtDb) database, there's a stored procedure named dbo.adm_cleanupmgmtdb. If you do run this stored procedure, all the entries in the database will be deleted.

It was documented in this article, which wasn't really on topic with the other content of the page: http://msdn.microsoft.com/en-us/library/aa561960.aspx

Nostalgic off-topic link: For some reason I always come to think about the starting sequence for "Anslagstavlan" when talking about clean slates. This link is completely irrelevant to BizTalk, it's swedish television from the 80's.

Filed under: ,

Comments

# BizTalk Linkflood, February 25, 2009 « ADA ICT Devsquad’s Blog said on February 25, 2009 12:02 PM:

Pingback from  BizTalk Linkflood, February 25, 2009 « ADA ICT Devsquad’s Blog

# Newly Noted #20 | Patrick Verbruggen's Blog said on February 25, 2009 07:22 PM:

Pingback from  Newly Noted #20 | Patrick Verbruggen's Blog

This Blog

News

    Messenger

    Twitter Updates

      Follow me on twitter

      Visitors

      Feedburner Subscribers

      Locations of visitors to this page

      Disclaimer

      All material is provided AS IS voiding any thinkable or unthinkable effect it might have for any use whatsoever. There... is that clear enough ;)

      Pages

    Syndication