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
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.
How useful was this post?
Click on a star to rate it!
Average rating / 5. Vote count: