Announcement

Collapse

Please Read: Significant Update Planned, Migrating Forum Software This Month

See more
See less

SQL Database in suspect mode issue

Collapse
X
  • Filter
  • Time
  • Show
Clear All
new posts

  • SQL Database in suspect mode issue

    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

  • #2
    Is it possible the previous (ALTER DATABASE with rollback) is still in progress
    How about a stop / start of the SQL engine between the two?
    Tom Jones
    MCT, MCSE (2000:Security & 2003), MCSA:Security & Messaging, MCDBA, MCDST, MCITP(EA, EMA, SA, EDA, ES, CS), MCTS, MCP, Sec+
    PhD, MSc, FIAP, MIITT
    IT Trainer / Consultant
    Ossian Ltd
    Scotland

    ** Remember to give credit where credit is due and leave reputation points where appropriate **

    Comment


    • #3
      Originally posted by Ossian View Post
      Is it possible the previous (ALTER DATABASE with rollback) is still in progress
      How about a stop / start of the SQL engine between the two?
      It is showing completed...

      Comment


      • #4
        Thank you.. I fixed the problem by using third party SQL database repair software. We read a MVP review of the software and use it:
        [MOD EDIT] We take a dim view of brand new members posting links to commercial sites (There has been too much spam in the past)
        Post edited and links removed [/MOD EDIT]
        Last edited by Ossian; 5th June 2018, 13:59.

        Comment

        Working...
        X