Uninstalling (removing) BizTalk Server does not remove SQL databases, SQL Server roles, SQL Server Agent jobs, SQL Server Integration Services Packages, SQL Server Analysis Services Databases, the groups that you created during configuration, or any items that you created in Visual Studio .NET. The BizTalk Server directory also preserves any files that you added.

You can manually delete the following BizTalk Server SQL Server Integration Services Packages when you remove BizTalk Server:

Or you can use this PowerShell script to delete all the BizTalk Server SQL Server Integration Services Packages:


dtutil /SQL BAM_DM_AS2InterchangeActivity /DELETE 
dtutil /SQL BAM_DM_AS2MdnActivity /DELETE 
dtutil /SQL BAM_DM_AS2MessageActivity /DELETE 
dtutil /SQL BAM_DM_BatchingActivity /DELETE 
dtutil /SQL BAM_DM_BatchInterchangeActivity /DELETE 
dtutil /SQL BAM_DM_BusinessMessageJournal /DELETE 


Note: A number of BizTalk Server databases and BizTalk Server-related jobs under SQL Server Enterprise Manager - SQL Server Agent still exists, including a BAM Analysis database that you also need to remove.

About me

Sandro Pereira
DevScope | MVP & MCTS BizTalk Server 2010
http://sandroaspbiztalkblog.wordpress.com/ | @sandro_asp