I am trying to drop a database in SQL Server 2014 which is permanently 'In Recovery'.
So I found these instructions on the internet:
ALTER DATABASE AdventureWorks2016CTP3
SET SINGLE_USER WITH ROLLBACK IMMEDIATE;
DROP DATABASE AdventureWorks2016CTP3
But that failed with these error messages:
Msg 5011, Level 14, State 7, Line 3
User does not have permission to alter database 'AdventureWorks2016CTP3', the database does not exist, or the database is not in a state that allows access checks.
Msg 5069, Level 16, State 1, Line 3
ALTER DATABASE statement failed.
Msg 3702, Level 16, State 4, Line 5
Cannot drop database "AdventureWorks2016CTP3" because it is currently in use.
Even if I go directly to the drive where the database data is situated it won't allow me to delete it there.
Please help !