Solved

Witness Disk Reserved in Windows 2008 Failover Cluster

Posted on 2009-05-04
4
3,184 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

Complete VMware vSphere® ESX(i) & Hyper-V Backup

Capture your entire system, including the host, with patented disk imaging integrated with VMware VADP / Microsoft VSS and RCT. RTOs is as low as 15 seconds with Acronis Active Restore™. You can enjoy unlimited P2V/V2V migrations from any source (even from a different hypervisor)

Join & Write a Comment

Scenario:  You do full backups to a internal hard drive in either product (SBS or Server 2008).  All goes well for a very long time.  One day, backups begin to fail with a message that the disk is full.  Your disk contains many, many more backups th…
The recent Microsoft changes on update philosophy for Windows pre-10 and their impact on existing WSUS implementations.
This tutorial will show how to push an installation of Backup Exec to an additional server in both 2012 and 2014 versions of the software. Click on the Backup Exec button in the upper left corner. From here, select Installation and Licensing, then I…
This tutorial will show how to configure a single USB drive with a separate folder for each day of the week. This will allow each of the backups to be kept separate preventing the previous day’s backup from being overwritten. The USB drive must be s…

758 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

17 Experts available now in Live!

Get 1:1 Help Now