Solved

Witness Disk Reserved in Windows 2008 Failover Cluster

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

What is SQL Server and how does it work?

The purpose of this paper is to provide you background on SQL Server. It’s your self-study guide for learning fundamentals. It includes both the history of SQL and its technical basics. Concepts and definitions will form the solid foundation of your future DBA expertise.

Question has a verified solution.

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

New Windows 7 Installations take days for Windows-Updates to show up and install. This can easily be fixed. I have finally decided to write an article because this seems to get asked several times a day lately. This Article and the Links apply to…
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 new Backup Exec 2012 server and move an existing database to that server with the use of the BEUtility. Install Backup Exec 2012 on the new server and apply all of the latest hotfixes and service packs. The…

733 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