locked
I cannot drop a database RRS feed

  • 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 RTM

    Thursday, June 9, 2016 1:47 PM

Answers

All replies