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.

Live Webinar: Active Directory Security: What Needs Immediate Priority!Live on Tuesday, October 12th at 1 PM ET

Attacks on Active Directory are at an all-time high. Companies that are not taking heed are being punished, both monetarily and with loss of production.

In this webinar, you will learn:

  • How to prioritize vulnerability management
  • What attackers are leveraging to breach organizations
  • Where Active Directory security needs immediate attention
  • Overall strategy to secure your environment and keep it secured

Sponsored by: