- This topic has 9 replies, 1 voice, and was last updated 9 years, 7 months ago by
.
-
Posts
-
-
-
That’s correct. You can build a little SQL script that does
Delete Database BizTalkMsgBox
Delete Database BizTalkMgmtDBetc…
Look for database that start with BizTalk, SSO, and/or contain “BAM” or “EDI”.
Neal
-
-
I deleted all BTS tables except one:
BizTalkMsgBoxDb
Can not delete/drop it. (error 3702)
This is still used by some service(I think), anyone knows which one?
-
I’ve had this problem a couple of times. Mostly restarting the computer helped. If not: Is IIS still running ? Could there be another PC trying to connect to the database ?
-
I get this error message:
TITLE: Microsoft SQL Server Management Studio
——————————Drop failed for Database ‘BizTalkMsgBoxDb’. (Microsoft.SqlServer.Smo)
——————————
ADDITIONAL INFORMATION:An exception occurred while executing a Transact-SQL statement or batch. (Microsoft.SqlServer.ConnectionInfo)
——————————
Cannot drop database “BizTalkMsgBoxDb” because it is currently in use. (Microsoft SQL Server, Error: 3702)
For help, click: http://go.microsoft.com/fwlink?ProdName=Microsoft+SQL+Server&ProdVer=09.00.3054&EvtSrc=MSSQLServer&EvtID=3702&LinkId=20476
——————————
BUTTONS:OK
—————————— -
I stopped and started the SQL server, and then took database offline and online again.
Then I could delete it 🙂
-
-
Sorry, I forgot:
Do you use the installation / deinstallation guides for BTS ? Otherwise you could run into some real trouble. They’re here:
http://go.microsoft.com/fwlink/?LinkId=81041
For instance, there are also a few SQL server agent jobs to be deleted etc.
Regards, Michael
-
-
-
-
-
-
-
-
- The forum ‘BizTalk 2004 – BizTalk 2010’ is closed to new topics and replies.