I meet problem when one node of cluster servers go down.
The backup node take the shared disk and IP , network
name, ..., but can not bring the sql server service on
line , failed several times.

Does anyone have pro exp. on this senario?

thanks

David Liu

MCSE/MCDBA

What kind of messages do you get in the SQL errorlogs, event viewer logs,
and cluster logs when you can't start SQL?

Have you tried to bring the resources in the SQL group online one by one to
verify whether it is actually the SQL resource that is failing (it could be
that something that depends on SQL, such as SQL Agent or Fulltext, can't
start and causes SQL to be stopped after it starts).

Does the problem only happen when one node crashes, or does it also happen
if you manually failover with "move group"?

Cindy Gross, MCDBA, MCSE
http://cindygross.tripod.com
This posting is provided "AS IS" with no warranties, and confers no rights.