SQL Database in suspect mode issue
- This topic has 3 replies, 1 voice, and was last updated 1 month ago by .
Viewing 2 posts - 1 through 2 (of 2 total)
Viewing 2 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic.
Home › Forums › Other Microsoft Servers and SaaS › SQL Server 2005 / 2008 / 2008 R2 / 2012 / 2016 › SQL Database in suspect mode issue
Tagged: SQL
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
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
You must be logged in to reply to this topic.
Find out more about our cookie policy here.