ID #1029

My Database is converted into suspect mode. How to solve?

Run the following query one by one :

EXEC sp_resetstatus 'yourDBname';

ALTER DATABASE yourDBname SET EMERGENCY

DBCC checkdb ('yourDBname')

ALTER DATABASE Data SET SINGLE_USER WITH ROLLBACK IMMEDIATE

DBCC CheckDB ('yourDBname', REPAIR_ALLOW_DATA_LOSS)

ALTER DATABASE yourDBname SET MULTI_USER

Note :  Replace yourDBname with your database name.

Click here for more info on how to run query.

Tags: -

Related entries:

You cannot comment on this entry