Answered by:
I cannot drop a database

Question
-
Dear all,
I've checked by using dm_exec_sessions and dm_exec_connections and nothing is opened.
No Sql Server Agent jobs against this database.
I've stopped services as well. Nothing.
No data collections enabled
Is like some snapshot is still opened but where look I for?
I am really stuck
use master; DROP DATABASE sysutility_mdv
Cannot drop the database 'sysutility_mdv', because it does not exist or you do not have permission.
--ALTER DATABASE sysutility_mdv SET SINGLE_USER WITH ROLLBACK IMMEDIATE use master; aLTER DATABASE sysutility_mdv SET RESTRICTED_USER wITH ROLLBACK IMMEDIATE; DROP DATABASE sysutility_mdv
Msg 5011, Level 14, State 5, Line 27
User does not have permission to alter database 'sysutility_mdv', the database does not exist, or the database is not in a state that allows access checks.
Msg 5069, Level 16, State 1, Line 27
ALTER DATABASE statement failed.alter database sysutility_mdv set offline;
Msg 5011, Level 14, State 5, Line 14
User does not have permission to alter database 'sysutility_mdv', the database does not exist, or the database is not in a state that allows access checks.
Msg 5069, Level 16, State 1, Line 14
ALTER DATABASE statement failed.Version: 2016 RTMThursday, June 9, 2016 1:47 PM
Answers
-
Olaf, after a while I've been able to delete it
Thanks
- Proposed as answer by Lin LengMicrosoft contingent staff Friday, June 10, 2016 3:16 AM
- Marked as answer by Lydia ZhangMicrosoft contingent staff Wednesday, June 29, 2016 2:02 AM
Thursday, June 9, 2016 2:31 PM
All replies
-
Trying to create one table:
Database 'sysutility_mdw' is in transition. Try the statement later. (Microsoft SQL Server, Error: 952)Thursday, June 9, 2016 1:56 PM -
-
Hello Olaf, No, I mean, main columns have usual values (ONLINE,MULTI_USER...)
How odd!
- Edited by Enric Vives Thursday, June 9, 2016 2:15 PM
Thursday, June 9, 2016 2:15 PM -
Olaf, after a while I've been able to delete it
Thanks
- Proposed as answer by Lin LengMicrosoft contingent staff Friday, June 10, 2016 3:16 AM
- Marked as answer by Lydia ZhangMicrosoft contingent staff Wednesday, June 29, 2016 2:02 AM
Thursday, June 9, 2016 2:31 PM