SQL Server Performance Forum – Threads Archive

suspected db causes

What are the possible cause to show that the database is suspect
I know one that is if ldf or mdf is deleted, by mistake.
What are the other causes?
If I have a suspect db how will I know what exactly happned?
and what should be first step to take and subsequent steps to make the db healthy

Lack of space? Luis Martin
Moderator
SQL-Server-Performance.com One of the symptoms of an approaching nervous breakdown is the belief that one’s work is terribly important
Bertrand Russell
All postings are provided â€œAS ISâ€ with no warranties for accuracy.

Check Event Viewer log for possible causes and in general as referred by Luis due to lack of disk space the database may not be able to write new data and will be kept under SUSPECT mode. Other causes such as a faulty disk or controller and operating system mismatch will also contribute this status. Satya SKJ
Moderator
http://www.SQL-Server-Performance.Com/forum
This posting is provided â€œAS ISâ€ with no rights for the sake of knowledge sharing.

Satya do you have a list of all the causes , so that I can have a step by step sol of all this in my Disaster Recovery Documentation.Moreover What is "operating system mismatch" is all about.Does it mean using sql server on other operating system other than Windows.

Write caching without UPS or on controllers without independent power supply. (may result in so called "torn pages" and suspect DBs).
P.S. MS SQL can’t run on OS other than Windows. WBR, Vlad A. Scherbinin

Hi aaronsandy, refer following for resetting / set the status to healthy db again : <a href=’http://www.sql-server-performance.com/forum/topic.asp?TOPIC_ID=9272&SearchTerms=suspect’ target=’_blank’ title=’http://www.sql-server-performance.com/forum/topic.asp?TOPIC_ID=9272&SearchTerms=suspect'<a target="_blank" href=http://www.sql-server-performance.com/forum/topic.asp?TOPIC_ID=9272&SearchTerms=suspect>http://www.sql-server-performance.com/forum/topic.asp?TOPIC_ID=9272&SearchTerms=suspect</a></a> <a href=’http://myitforum.techtarget.com/articles/18/view.asp?id=7381′ target=’_blank’ title=’http://myitforum.techtarget.com/articles/18/view.asp?id=7381′<a target="_blank" href=http://myitforum.techtarget.com/articles/18/view.asp?id=7381>http://myitforum.techtarget.com/articles/18/view.asp?id=7381</a></a> [<img src=’/community/emoticons/emotion-1.gif’ alt=’

‘ />] Regards. hsGoswami [email protected] "Humans don’t have Caliber to PASS TIME , Time it self Pass or Fail Humans" – by Hemant Goswami

There is no such documentation available for causes of suspect, rather follow referred articles for more information. Sometimes if you apply any service pack or hotfix on operating system then you may get spurious errors which in this case you must test any patch that is going to be applied on production server. Satya SKJ
Moderator
http://www.SQL-Server-Performance.Com/forum
This posting is provided â€œAS ISâ€ with no rights for the sake of knowledge sharing.

]]>