[Solved]: Suspect database in sql server 2012 – Sweksha

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 *