Coming Soon: GET:IT Endpoint Management 1-Day Conference on September 28th at 9:30 AM ET Coming Soon: GET:IT Endpoint Management 1-Day Conference on September 28th at 9:30 AM ET

SQL Database in suspect mode issue

Tagged: 

Viewing 2 posts - 1 through 2 (of 2 total)
  • Author
    Posts

  • DazyParker
    Member
    #167577

    Hello Folks,

    I am using SQL Server 2014 Enterprise Edition on Windows 2012

    My SQL database was in suspect mode so, I tried the following:

    ALTER DATABASE db_name SET EMERGENCY – Completed
    DBCC CheckDB ([MyDB_Prod] — Completed
    ALTER DATABASE MyDB_Prod SET SINGLE_USER WITH rollback immediate; — Completed
    DBCC CheckDB ([MyDB_Prod], REPAIR_ALLOW_DATA_LOSS); — Failed due to below error.

    Nonqualified transactions are being rolled back. Estimated rollback completion: 0%.

    Msg 924, Level 14, State 1, Line 5
    Database ‘MyDB_Prod’ is already open and can only have one user at a time.

    My Questions are:
    The database in single user mode then, why I am getting the error, it can be used one user at a time.

    It is not allowing me shut down the DB MyDB_Prod

    Please help me to fix this..

    Thanks in advance

    Regards,
    Dazy


    Sean_Smith
    Participant
    #654322

    I know it is an old question but, no one answered it. I have faced the same issue with my Prod DB.

    This forum helped me to fix the issue. https://social.msdn.microsoft.com/Forums/sqlserver/en-US/e3a99821-2231-48ed-b77a-c1af2f85d6e9/msg-924-level-14-state-1-error-during-running-script-in-database-in-single-user-mode-for-sql?forum=transactsql

Viewing 2 posts - 1 through 2 (of 2 total)

You must be logged in to reply to this topic.