Sometimes, you screw up your BizTalk configuration, and rather than trying to fix it up, it’s better to just delete your databases and start afresh.
Here is a script that I use to do just that – it also closes your existing connections:
IF EXISTS (SELECT name FROM sys.databases WHERE name = N'BAMArchive') ALTER DATABASE BAMArchive SET SINGLE_USER WITH ROLLBACK IMMEDIATE DROP DATABASE BAMArchive GO IF EXISTS (SELECT name FROM sys.databases WHERE name = N'BAMPrimaryImport') ALTER DATABASE BAMPrimaryImport SET SINGLE_USER WITH ROLLBACK IMMEDIATE DROP DATABASE BAMPrimaryImport GO IF EXISTS (SELECT name FROM sys.databases WHERE name = N'BAMStarSchema') ALTER DATABASE BAMStarSchema SET SINGLE_USER WITH ROLLBACK IMMEDIATE DROP DATABASE BAMStarSchema GO IF EXISTS (SELECT name FROM sys.databases WHERE name = N'BizTalkDTADb') ALTER DATABASE BizTalkDTADb SET SINGLE_USER WITH ROLLBACK IMMEDIATE DROP DATABASE BizTalkDTADb GO IF EXISTS (SELECT name FROM sys.databases WHERE name = N'BizTalkMgmtDb') ALTER DATABASE BizTalkMgmtDb SET SINGLE_USER WITH ROLLBACK IMMEDIATE DROP DATABASE BizTalkMgmtDb GO IF EXISTS (SELECT name FROM sys.databases WHERE name = N'BizTalkMsgBoxDb') ALTER DATABASE BizTalkMsgBoxDb SET SINGLE_USER WITH ROLLBACK IMMEDIATE DROP DATABASE BizTalkMsgBoxDb GO IF EXISTS (SELECT name FROM sys.databases WHERE name = N'BizTalkRuleEngineDb') ALTER DATABASE BizTalkRuleEngineDb SET SINGLE_USER WITH ROLLBACK IMMEDIATE DROP DATABASE BizTalkRuleEngineDb GO IF EXISTS (SELECT name FROM sys.databases WHERE name = N'SSODB') ALTER DATABASE SSODB SET SINGLE_USER WITH ROLLBACK IMMEDIATE DROP DATABASE SSODB GO
