'How to Force Drop a Database that is in Emergency Mode and corrupt?

In SQL Server 2014. We have a database that is in Emergency mode and is corrupt beyond repair. We need to get rid of it and reclaim the space. But we're having trouble as the database isn't even recognized, event though it is listed under Object Explorer.

We've tried straight forward DROP, but didn't work.

Tried this: ALTER DATABASE DBNAME SET SINGLE_USER WITH ROLLBACK IMMEDIATE; DROP DATABASE DBNAME; But didn't work.

Can't even Detach it.

What can we do here?

sql-serversql-server-2014


Sources

This article follows the attribution requirements of Stack Overflow and is licensed under CC BY-SA 3.0.

Source: Stack Overflow

Solution Source

Related Questions