[Okta Webinar] Learn how to a build a cloud-first strategyRegister Now

x
  • Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 3310
  • Last Modified:

Witness Disk Reserved in Windows 2008 Failover Cluster

I have a Windows 2008 failover cluster which serves a SQL Server 2005 service in a node and disk majority.  The witness disk and SQL Server disks(Data, Logs, Indexes, etc.) are all connected through an iSCSI SAN connection.  On the inactive node, the witness disk is shown as reserved but is not "online" (which I think is evidenced by the fact that the drive letter is not shown in disk management).  Is this normal?  Is the witness disk accessible from only one server at a time?
Secondly, each server shows the witness disk properties as Type=basic, Status=Reserved, and Partition Style=GUID Partition Table(GPT).  Is that normal and expected?
Thanks
0
dbeutler
Asked:
dbeutler
  • 2
  • 2
1 Solution
 
mfreudenCommented:
Yes and Yes.

I assume you're viewing the disk-status in the "Server Manager" - "Disk Management" window.  You will also see Clusted disks as reserved here.

The disks showing as Type=basic, Status=Reserved, and Partition Style=GUID Partition Table(GPT) is perfectly normal.

Yes, you can only access the shared disks by 1-node at a time.

To get a better feel for what's happening in your cluster, use the "Custer Failover Management" program in the "Administration Tools" folder.  Here you'll see the disks online and which node has control.



0
 
dbeutlerAuthor Commented:
Don't both nodes need access to the Witness disk?
0
 
dbeutlerAuthor Commented:
What I meant to say was, Don't both nodes need access to the Witness Disk at the same time?  (BTW-You will be awarded the points)
0
 
mfreudenCommented:
There are 4 types of quorum configurations for Wiundows Sever 2008:

Node Majority: Each node that is available and in communication can vote. The cluster functions only with a majority of the votes, that is, more than half.


Node and Disk Majority: Each node plus a designated disk in the cluster storage (the disk witness) can vote, whenever they are available and in communication. The cluster functions only with a majority of the votes, that is, more than half.


Node and File Share Majority: Each node plus a designated file share created by the administrator (the file share witness) can vote, whenever they are available and in communication. The cluster functions only with a majority of the votes, that is, more than half.


No Majority: Disk Only: The cluster has quorum if one node is available and in communication with a specific disk in the cluster storage. Only the nodes that are also in communication with that disk can join the cluster.


You can tell which Quorum configuration you are using in the "failover cluster management" program. on the server properties.  I use "No Majority Disk Only", which is only viewable by the active node (in windows explorer).  I'm not sure about the other 3 options.  Even though the 2nd node can't acess the drive directly via windows explorer, the servers communicate with each other and verify that the disk will be availbe on a failover event.  

All of this is validated at the time you join the clusted with a node.

The best way to see if things are working correctly is to fail the cluster over and see if everything is accessible on the 2nd node.  If so, you're fine.
0

Featured Post

Has Powershell sent you back into the Stone Age?

If managing Active Directory using Windows Powershell® is making you feel like you stepped back in time, you are not alone.  For nearly 20 years, AD admins around the world have used one tool for day-to-day AD management: Hyena. Discover why.

  • 2
  • 2
Tackle projects and never again get stuck behind a technical roadblock.
Join Now