I have a database on the passive node that frequently gets marked "suspect." I'm looking for any insight as to why this might happen, as well as how to best handle the suspect database - restore, replicate, etc

Any information is greatly appreciated

Thanks

When a database is marked suspect, SQL Server almost always writes a message
to the errorlog giving the reason. Please check there and let us know what
it says. How to handle it depends on WHY it is marked suspect.

--
HTH
----------------
Kalen Delaney
SQL Server MVP
www.SolidQualityLearning.com


[quoted text, click to view]
"suspect." I'm looking for any insight as to why this might happen, as well
as how to best handle the suspect database - restore, replicate, etc.
[quoted text, click to view]