[Solved]: Suspect database in sql server 2012

To solve this problem you need microsoft sql server management studio. Open with administrator access. Now open new query and use the below query. Replace my_db with your database.

EXEC sp_resetstatus my_db;
ALTER DATABASE my_db SET EMERGENCY
DBCC checkdb(my_db)
ALTER DATABASE my_db SET SINGLE_USER WITH ROLLBACK IMMEDIATE
DBCC CheckDB (my_db , REPAIR_ALLOW_DATA_LOSS)
ALTER DATABASE my_db SET MULTI_USER

Restart management studio and you can see that suspect sign is removed and database is accessible.

 

 

Leave a Reply

Your email address will not be published. Required fields are marked *