Solved

Witness Disk Reserved in Windows 2008 Failover Cluster

Posted on 2009-05-04
4
3,201 Views
Last Modified: 2012-05-06
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
Comment
Question by:dbeutler
  • 2
  • 2
4 Comments
 
LVL 3

Accepted Solution

by:
mfreuden earned 500 total points
ID: 24297292
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
 

Author Comment

by:dbeutler
ID: 24297345
Don't both nodes need access to the Witness disk?
0
 

Author Comment

by:dbeutler
ID: 24297348
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
 
LVL 3

Expert Comment

by:mfreuden
ID: 24297513
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

Netscaler Common Configuration How To guides

If you use NetScaler you will want to see these guides. The NetScaler How To Guides show administrators how to get NetScaler up and configured by providing instructions for common scenarios and some not so common ones.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

To effectively work with Diskpart on a Server Core, it is necessary to write some small batch script's, because you can't execute diskpart in a remote powershell session. To get startet, place the Diskpart batch script's into a share on your loca…
I was supporting a handful of Windows 2008 (non-R2) 2 node clusters with shared quorum disks. Some had SQL 2008 installed and some were just a vendor application that we supported. For the purposes of this article it doesn’t really matter which so w…
To efficiently enable the rotation of USB drives for backups, storage pools need to be created. This way no matter which USB drive is installed, the backups will successfully write without any administrative intervention. Multiple USB devices need t…
This tutorial will walk an individual through the process of transferring the five major, necessary Active Directory Roles, commonly referred to as the FSMO roles to another domain controller. Log onto the new domain controller with a user account t…

863 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question

Need Help in Real-Time?

Connect with top rated Experts

28 Experts available now in Live!

Get 1:1 Help Now