What is SUSPECT Mode database?

Question

Hi All,

What is suspect mode in sql server and how it happens and how to recover from the suspect database ?\

Please post the article.

---

Thanks&Regards Siva G

Answer 1

Here is a previous thread with many suggestions:

http://social.msdn.microsoft.com/Forums/en/transactsql/thread/f3c8d2e6-125a-48da-b38f-7b4df534bf8f

Thanks,
Sam Lester (MSFT)

---

This posting is provided "AS IS" with no warranties, and confers no rights. Please remember to click "Mark as Answer" and "Vote as Helpful" on posts that help you. This can be beneficial to other community members reading the thread.

Answer 2

SQL server marks database as suspect due to many reasons; some of them are given below:

Hardware failure
Improper shutdown of the database server
Corruption of the database files
Unavailable device files
Unavailable database files
Database resource used by operating system
SQL Server incorrectly asserts free data page space when a row is inserted 


For details click here
http://www.karaszi.com/SQLServer/info_corrupt_suspect_db.asp
http://www.stellarinfo.com/support/kb/index.php/article/procedure-to-recover-sql-database-from-suspect-mode

---

Please click "Propose As Answer" if a post solves your problem or "Vote As Helpful" if a post has been useful to you