SQL Database in suspect mode issue

[DazyParker]

#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]

#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

[Author]

Posts