Windows 7 What to do if the database under MS SQL went to Suspect Mode?

alainmarion85 · Jul 16, 2015

In the work I came up against a situation when the working database at the end of day went to the Suspect Mode. And the archive was in many hours before. To transfer it in normal mode, until isn't made repaired base it was impossible. DBCC checkdb also refused to run because the database is in this mode. What to do in this case?

Josephur · Jul 16, 2015

What version of MS SQL are you using?

Backup the database if at all possible before trying any of this, I'm not responsible if you nuke your data!

You need to login to the database as the sa user and perform some maintenance.
EXEC sp_resetstatus 'database_name';
ALTER DATABASE database_name SET EMERGENCY;
DBCC checkdb('database_name');

Josephur · Jul 16, 2015

What version of MS SQL are you using?

Backup the database if at all possible before trying any of this, I'm not responsible if you nuke your data!

You need to login to the database as the sa user and perform some maintenance.
EXEC sp_resetstatus 'database_name';
ALTER DATABASE database_name SET EMERGENCY;
DBCC checkdb('database_name');

Taylor Wallis · Apr 3, 2017

alainmarion85 said:
DBCC checkdb also refused to run because the database is in this mode.

You sure? I mean the primary function of DBCC DBREPAIR (you didn't mention) and DBCC CHECKDB is to fix SQL database which is tagged as suspect. How does it refuse to run?

Windows 7 What to do if the database under MS SQL went to Suspect Mode?

alainmarion85

New Member

Josephur

Josephur

Windows Forum Admin

Taylor Wallis

Well-Known Member

Similar threads