Server Fault is a question and answer site for system and network administrators. It's 100% free, no registration required.

Sign up
Here's how it works:
  1. Anybody can ask a question
  2. Anybody can answer
  3. The best answers are voted up and rise to the top

I'm in the middle of server maintenence, I upgraded 1 node's bios and windows updates and now I'm attempting to failover our database cluster to the passive, updated node. It fails over fine, but two of the 8 databases end up "suspect".

Could this be because of the windows updates or bios update?

Edit: I am using the cluster move group command from the cluster administrator.

When I move it back the suspect goes away and everything functions fine. The issue is only on the one node.

share|improve this question

Sounds like you have a database connected to a drive that isn't setup on the cluster, or the dependencies aren't setup correctly. This will cause the SQL Server to start before the disks are ready which will cause the database to go suspect.

Check the ERRORLOG and see what the reason for the database going suspect is.

share|improve this answer

Anything is possible but I'd be more inclined to check the hard drive (or RAID) for problems first.

Ask yourself the following:

  1. What else has recently changed (that could be a more likely cause) in your environment?

  2. Take a look at your SQL Server logs to see if you can determine WHEN the error occurred. Does this correspond with your BIOS update and Windows Update theory?

  3. Talk to your team members to ask them what changes have been made and when.

  4. See if the issue has occurred on any other servers in your environment.

share|improve this answer
Suspect only happens when the second machine owns the cluster group. If I move it back there is no longer any problem. – Aaron Jensen Jul 9 '09 at 19:11

How are you failing over? I hope you're using the CLUSTER GROUP /MOVE command, or at least through the MMC - MOVE GROUP.

I hate seeing the term "failover" when talking about clusters.

share|improve this answer
Sorry, yes you're right, I used cluster group/move. My bad on the terminology :) – Aaron Jensen Jul 9 '09 at 19:10

I suspect (pun intended) databases that are having problems have shared storage drives that are not seen correctly by windows at the OS level.

Check that when you fail over that you can navigate to the shared drives & find the mdf & ldf files for these databases, if not then you should remove the node from the cluster & re-initalize the shared drives on the server.

share|improve this answer

Your Answer


By posting your answer, you agree to the privacy policy and terms of service.

Not the answer you're looking for? Browse other questions tagged or ask your own question.