ConfigMgr SUSDB Deletion Error – Cannot drop database SUSDB

I got an error while deleting the ConfigMgr SUSDB. The error was cannot drop database “SUSDB” because it is currently in use.

I recently had to rebuild my ConfigMgr technical preview lab. That’s because the ConfigMgr technical preview version got expired. I had no other option apart from reinstalling it.

When you install WSUS for SCCM, you may notice that SUSDB isn’t created on your SQL Server. That’s because you haven’t performed the WSUS post installation tasks.

After you perform the WSUS post installation tasks, the SUSDB should be visible under Databases.

Cannot Drop Database SUSDB

During the ConfigMgr TP removal, I decided to delete the SUSDB from databases however it didn’t work. I could see the error Cannot drop database “SUSDB” because it is currently in use.

Another error was drop failed for Database SUSDB. More details listed below.

TITLE: Microsoft SQL Server Management Studio

Drop failed for Database 'SUSDB'. (Microsoft.SqlServer.Smo)

ADDITIONAL INFORMATION:

An exception occurred while executing a Transact-SQL statement or batch. (Microsoft.SqlServer.ConnectionInfo)

Cannot drop database "SUSDB" because it is currently in use. (Microsoft SQL Server, Error: 3702)

Fix ConfigMgr SUSDB Deletion Error

So in case you are encountering the error during SUSDB deletion here is the fix.

Login to the SQL Server Management Studio and connect to Database Engine. Now expand databases and right click SUSDB. To delete the SUSDB, click Delete option.

On the Delete Object window, notice that you see two options.

• Delete backup and restore history information for databases.
• Close existing connections.

Let’s assume you only check the first option and click OK.

Now you get an error Drop failed for database SUSDB.

Let’s try again. Right click the SUSDB and click Delete. This time you select the second option Close existing connections. This should fix the SUSDB deletion issue.

What I understand is you will need to close all the existing database connections in a database before deleting it. If you try to drop a database when users are connected to the SQL Server Database, you will receive SUSDB drop failed error.