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
Troy Laughlin

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


"Troy Laughlin" <anonymous (AT) discussions (DOT) microsoft.com> wrote

as how to best handle the suspect database - restore, replicate, etc.