Settings » FR6 Setting

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: -

Last update: 2011-05-28 09:30
Author: Admin
Revision: 1.2

Digg it! Print this record Send FAQ to a friend Show this as PDF file
Propose a translation for Propose a translation for
Please rate this FAQ:

Average rating: 5 out of 5 (1 Votes )

completely useless 1 2 3 4 5 most valuable

You cannot comment on this entry