SQL Database in suspect mode issue

This topic contains 2 replies, has 3 voices, and was last updated by  fpenn 6 months, 1 week ago.

Viewing 3 posts - 1 through 3 (of 3 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


    Ossian
    Moderator
    #192021

    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?


    fpenn
    Member
    #392043
    Ossian;n517219 wrote:
    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…

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

You must be logged in to reply to this topic.