Quorum on node 2 (passive) sqlserver 2008 R2 cluster on windows server 2008 R2 is fine?

Question

We have active/passive sqlserver 2008 R2 cluster on windows 2008 R2 cluster.Recently we did fail over and then back to active.But quorum still on passive node.Is it fine to keep quorum on passive?

thanks,

Ron.

Answer 1

Having cluster group on other node should not be an issue. If you want to move cluster group then you can follow the below article

http://blogs.msdn.com/b/joesack/archive/2009/01/08/windows-server-2008-how-to-move-the-quorum-disk-group.aspx

Answer 2

Hi there,

It is completely fine. YOur disks will be in sync any way. when a crash happens on other node your disks will online on the active node.

if you restart That may bring the disks online on the active node.

How ever if you want to bring the disks on the active node you can do that. Open teh cluster manager then open the nodes right click and you find the option to move to active node.

thanks

kumar

Answer 3

it is irrelevant where the cluster group is running on, since this will failover if there are any problems. Your post loosely suggests you may be running a disk only quorum, and if this is the case you should seriously consider changing to node majority plus shared disk configuration for improved availability of your cluster.

---

Regards,
Mark Broadbent.

Contact me through (twitter|blog|SQLCloud)

---

Please click "Propose As Answer" if a post solves your problem
or "Vote As Helpful" if a post has been useful to you
Watch my sessions at the PASS Summit 2012