SQL Server

SQL Server Failover Cluster – modifying the quorum drive

- by Amit Bansal - Leave a Comment

Hi Friends,

Last week, I was playing around with SQL Server Failover clusters and setup SQL Server Failover clutser using 3 Hyper-V images. I am writing a series of blog posts just to pen down a few notes.

In this 2nd post of the series, I want to talk about changing the quorum drive.

When you setup Windows Failover Clustering, one of the drives is chosen as a quorum drive. After the installation, you can change the quorum drive as follows:

Connect to Failover Cluster Manager (Server Manager -> Features -> Failover Cluster Manager)

Right Click the cluster -> More Actions -> Configure Cluster Quorum Settings

1_SQL_Server_Failover_Cluster_modifying_the_quorum_drive

Click Next on the welcome screen.

Choose the quorum setting, click Next.

   

2_SQL_Server_Failover_Cluster_modifying_the_quorum_drive

Choose the drive, click Next.

3_SQL_Server_Failover_Cluster_modifying_the_quorum_drive

Click Next on confirmation page, and you are done !

The quorum drive will have the following folder:

4_SQL_Server_Failover_Cluster_modifying_the_quorum_drive

 

 

   

Related Posts

SQL Server Query Cost, Memory Grant & SQLRESERVATIONS Clerk

SQL Server Memory Troubleshooting

Performance Monitor Counters

About Amit Bansal

Amit Bansal is always brainstorming around SQL Server. Despite working with SQL since 1997, he is amazed that he keeps learning new things every single day. SQL Server is AB's first love, and his wife does not mind that. He tries to share as much and spreads the SQL goodness. Internals and Performance Tuning excites him, and also gives him sleepless nights at times, simply because he is not a genius, but quite a hard worker and does not give up. It has been a long and exciting journey since 1997, you can read here: http://sqlmaestros.com/amit-bansal/ He is on Twitter: https://www.twitter.com/A_Bansal

View all posts by Amit Bansal →

Leave a Reply

Your email address will not be published.