Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
sqlguy7777
Starting Member
14 Posts |
 Posted - 2010-12-23 : 18:09:18
|
| HiI have a SQL 2008 R2 cluster on Windows 2008 R2. I have boon looking for away to make the quorum disk a dependency on SQL, so when SQL fails over, it will automtaically take the quorum with it.Or, if I cant do that, how do I set up the cluster so that if ANY one resource ( e.g. a single disk ect ) fails over, it will force a full failover of all resources to the other node?Thanks in advance,SG |
|
|
tkizer
Almighty SQL Goddess
38200 Posts |
|
|
sqlguy7777
Starting Member
14 Posts |
Posted - 2010-12-23 : 20:07:49
|
| My idea was that if a node failed, all resources e.g. SQL, quorum etc would fail across to the second node. I figured that you would have the quorum linked to SQL so it all failed over together, or is that faulty thinking?Am I looking at how clusters should work all wrong?I just noticed I can associate drives with applications etc within th elcuster, so I thought perhaps it would be a good idea to associate the Quorum with SQL just in case we had a partial failover of all resources for some reason....and I didnt want a cluster straddling two servers in a semi failed-over state. |
 |
|
|
tkizer
Almighty SQL Goddess
38200 Posts |
Posted - 2010-12-23 : 20:13:07
|
| If a node fails, all cluster resources will failover to the other node. When both nodes are online, it is not necessary to split the resources up amongst the nodes. I leave the Quorum drive wherever it lands. A cluster straddling two servers is not a problem. A resource only runs one node at a time. SQL Server doesn't care about the Quorum drive and vice versa. The cluster service itself care about the Quorum drive. And SQL cares about the cluster service.Tara KizerMicrosoft MVP for Windows Server System - SQL Serverhttp://weblogs.sqlteam.com/tarad/Subscribe to my blog |
|
|
|
sqlguy7777
Starting Member
14 Posts |
Posted - 2010-12-23 : 21:01:42
|
| Ah..I just figured that a cluster straddling two nodes might be an issue if one goes down and its ungraceful...unless I'm worried unnecessarily that the cluser service wont gracefully handle things in a catastrophic power-off of one cluster server.am I being overly cautious? |
|
|
|
tkizer
Almighty SQL Goddess
38200 Posts |
|
|
|
|
|
|
|
Any resouce failing over cause all failover - how?