question

plutodev avatar image
plutodev asked

What is the cause for Database goes to SUSPECT MODE

Hi friends What is the cause for Database goes to SUSPECT MODE ? and how to recover suspect mode to normal mode ? Regards Thankss a lot
sql-server-2005
10 |1200

Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.

Pavel Pawlowski avatar image
Pavel Pawlowski answered
There can be a lot of reasons, some of them are: 1. Improper shutdown of the SQL Server Service (like kill of the service, hard restart of machine) 2. Hardware failure 3. Not enough disk space when writing data 4. Various corruptions of db file
10 |1200

Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.

Magnus Ahlkvist avatar image
Magnus Ahlkvist answered
A database is marked Suspect for a number of reasons, like - If the database is set to Autoclose, and another process holds a lock on the database file when SQL Server tries to bring it online (I think SQL Server Express has autoclose on as default, at least that was the case with MSDE) - There's could be corruption in the file (disk error etc) so SQL Server can't bring the database online. - The transaction log has been corrupted, deleted etc. If you have Auto Close on, you could just restart SQL Server, see if the database goes online and if it does; change that option to off. Tibor Karaszi has a short article about what to do if you really have a corrupted database: [ http://www.karaszi.com/SQLServer/info_corrupt_suspect_db.asp][1] [1]: http://www.karaszi.com/SQLServer/info_corrupt_suspect_db.asp
10 |1200

Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.

elliswhite avatar image
elliswhite answered
10 |1200

Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.

RonakSompura avatar image
RonakSompura answered
Improper handling of Begin Transaction .. End Transaction / Roll Back
10 |1200

Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.

realfate avatar image
realfate answered
the most cause is the interruption of the data stream either from the network or locally, this interruption can be caused of many reasons, network, electricity, machine hanging, breack of CPU and RAM resources
10 |1200

Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.

jason_clark03 avatar image
jason_clark03 answered
There may be various cause which leads database to go in suspect mode !! You may have a look in this: http://blog.systoolsgroup.com/sql-suspect-database-recovery.html
10 |1200

Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.

Markdc avatar image
Markdc answered

There are many causes of database going into suspect mode. Few of the reasons are

  • When the user couldn’t find the specified file during the creation or opening of the physical device.
  • The system failed to open the device where the data or the log files are present.
  • Low Disk Space.

To know the other details and reasons, you can follow:

http://www.databasefilerecovery.com/blog/know-how-to-recover-sql-database-from-suspect-mode.html

10 |1200

Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.

Write an Answer

Hint: Notify or tag a user in this post by typing @username.

Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.