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 |
|
bozard
Starting Member
2 Posts |
 Posted - 2010-10-12 : 15:59:36
|
| I set up a SQL cluster a while back that seems to be working just fine.My question is to satisfy my understanding of the quorum drive placement.Currently I have 2 x 2008 servers. Node1 and Node2. SQL 2005 is used for the cluster. I have 3 drives. 1 for the data, 1 for the logs and 1 for the quorum.I had always thought that the active node should always have all 3 drives. But, for some reason the cluster seems to run O.K. with having the data and logs drives on the active cluster while having the quorum on the passive node. The backups seem to run better when this is the case.Is this O.K.?Also, is there a good paper on setting up a cluster for 2008R2 with SQL 2008R2? I need to set this up later this month.Thanks! |
|
|
tkizer
Almighty SQL Goddess
38200 Posts |
Posted - 2010-10-12 : 16:05:20
|
| Yes that is okay. The quorum drive just needs be up for the cluster to work, it doesn't matter which node it resides on.http://www.windowsnetworking.com/articles_tutorials/Cluster-Quorums.htmlhttp://technet.microsoft.com/en-us/library/bb124225(EXCHG.65).aspxI don't have any documentation for setting up a cluster for Win2k8R2/SQL2k8R2, but there is lots of stuff out there that can be found by googling it. I will note that the SQL Server 2008 and 2008 R2 installation is much, much better on a cluster than it was on SQL Server 2005, however I have encountered more errors with the installer on 2008 than I did with 2005. Ensure that your SQL Server service account has full permissions to create and delete SPNs to avoid the issues I've encountered.Tara KizerMicrosoft MVP for Windows Server System - SQL Serverhttp://weblogs.sqlteam.com/tarad/Subscribe to my blog |
 |
|
|
bozard
Starting Member
2 Posts |
Posted - 2010-10-12 : 16:20:13
|
| Thank you very much!This was the first production cluster I have built. I now need to build two more by the end of the year. So any help is greatly appreciated.B |
|
|
|
russell
Pyro-ma-ni-yak
5072 Posts |
Posted - 2010-10-12 : 20:01:52
|
| here's the 2k8 white paperhttp://download.microsoft.com/download/6/9/D/69D1FEA7-5B42-437A-B3BA-A4AD13E34EF6/SQLServer2008FailoverCluster.docx |
|
|
|
|
|
|
Quorum Drive