Sql Database Suspect Mode?

Database Suspect Mode?
Database go into SUSPECT mode because the primary filegroup is damaged and the database cannot be recovered during the startup of the SQL Server. Generally when the database is in SUSPECT mode, nobody can deal with the data.

but you can recover the suspect mode, first of all you need to change the mode from suspect to emergency
Code: [Select all]
ALTER DATABASE dbName SET EMERGENCY

after that you need to set your database for single user
Code: [Select all]
ALTER DATABASE dbName SET SINGLE_USER

Then you can run DBCC CheckDB command. This command checks the allocation, structural, logical integrity and errors of all the objects in the database.
Code: [Select all]
DBCC CheckDB (dbName , REPAIR_ALLOW_DATA_LOSS)

after doing all, final you can set back to multiuser
Code: [Select all]
ALTER DATABASE dbName SET MULTI_USER

----------------------------------
URL:
http://www.dotnetobject.com/Thread-Database-Suspect-Mode