What is database suspect mode ?
A database is always in a specific status such as online, offline, recovering, restoring, emergency, suspect, etc. Among them today we are going to discuss about suspect mode. If a database go into suspect mode we cannot work on it or at least can’t connect to the database until it becomes online mode. The main reason for a suspect status is damaging the primary filegroup of the database. So to recover this issue we have to perform some specific actions. What are the reasons to marks database as Suspect? Hardware failure. Database server is not shutdown properly. Corruption of the database files. Missing database logging files Low disk spaces. SQL cannot complete a rollback or roll forward operations. Steps to recover the Suspect mode of database Open SQL Server Management Studio. Select New Query and we have to turn on emergency mode.by turn on the emergency mode it allows read only access to the administrator. We can do it by, ALTER DATABASE