locked
Database on single usr and unable to set multi user RRS feed

  • Question

  • Hi I make the DB in to single user mode and not  able able to set in. it says deadlocked

    use master

    ALTER DATABASE DBname SET MULTI_USER;

    Msg 1205, Level 13, State 68, Line 16
    Transaction (Process ID 56) was deadlocked on lock resources with another process and has been chosen as the deadlock victim. Rerun the transaction.
    Msg 5069, Level 16, State 1, Line 16
    ALTER DATABASE statement failed.

    +++++++++++++

    when I try to kill 56

    Msg 6104, Level 16, State 1, Line 17
    Cannot use KILL to kill your own process.

    +++++++++++++++

    I restart the instance . Still available .Please note I cant reboot server for business issue

    any help great thanks 



    • Edited by ashwan Tuesday, May 29, 2018 2:21 AM
    Tuesday, May 29, 2018 2:12 AM

Answers

  • Its worked after reboot the server. But with the solution I am  not happy. fixing one DB has interrupted other DBs users . May be a SQL Bug. Version is 2014 STD 64 bit.

    Many thanks for comment Uri


    • Edited by ashwan Wednesday, May 30, 2018 9:36 PM
    • Marked as answer by ashwan Wednesday, May 30, 2018 9:36 PM
    Wednesday, May 30, 2018 9:35 PM

All replies