Adding a new disk to a SQL Server Cluster Instance

In order to do anything involving a SQL Server clustered instance (restore, backup, store/read data) storage must be accessible to the clustered instance. Here we will discuss the process of how to add a new LUN to a SQL cluster.

First off, have your storage admin add the disk, and make it accessible to all of the nodes of the cluster. Most SANs are different, so I’m not going to discuss that syntax here.

The next step is a little painful, you need to go to each of your cluster nodes and do a rescan of storage. In order to do this, go to Server Manager and right click on Disk Management > Rescan Disks

Next, go the server where the cluster service you would like to add the disk to is running (you can accomplish this by entering the virtual cluster name into Terminal Services) and online the disk (From Disk Management)

After the disk is brought online, it must be initialized. This is done from the same disk management dialogue. Configure this with either a MBR or GUID partition table (preferable for very large LUNS).

Next create the volume, in order to this, right click in the disk area, and select “New Simple Volume”

To create this drive under an existing drive letter (which I like to do for clustering) select “Mount in the following empty NTFS folder”

Create a new folder under the drive letter associated with your cluster resource group. I typically name the folder $RESOURCE_GROUP_$PURPOSE. Where resource group would RG1_ and purpose would be backup/data/logs.

Lastly, you need to label your volume and format. Once again for clarity, I usually for $RESOURCE_GROUP_Identifier_$PURPOSE_$LUN#.

Next, launch failover cluster manager (this can run either on your server or desktop). Select manage a cluster, and the enter the name of the cluster you are managing (if it doesn’t auto-populate)

Right click on the Storage folder on the right and select add a disk. If the disk is presented and configured properly, the cluster should see it, and add it to available disks.

Expand the left hand window and select “Services and Applications”

Right click on the instance you would like to add the storage to, and select “Add Storage”. A dialogue box will pop up with the available disks to add.

This is where you select the appropriate disk and add it into your cluster. You should be able to identify by its disk number and volume information.

Go into SSMS and using the Attach  Database dialogue (or any dialogue that interacts with the files system–backup/restore, etc), and verify that SQL Server can see the disk.

About jdanton1
A DBA, cyclist, cook (who likes to play chef occasionally)

12 Responses to Adding a new disk to a SQL Server Cluster Instance

  1. Carl Walden says:

    That is nicely written and I like the explanation as I will be using it as part of my documentations.

    • Shaun says:

      I tried this and everythin went as planned but I can’t see the dirves when I try to attach the databases.

      • Justin Burnard says:

        I have the same problem as Shaun. I can see the disk in cluster manger as storage for my SQL cluster. However when I’m in SSMS I’m unable to see the new storage. Shaun did you find a solution?

  2. Pingback: SQL Server Clustering — Why you should use mount points « The SQL Herald

  3. Pingback: SQL Server Cluster SAN Migration–Part I The Easy Way « The SQL Herald

  4. Pingback: The SQL Herald

  5. mehsah02 says:

    Nice post.
    But it’s is missing.

    In Failover Cluester Management
    SQL Server properties-> Dependencies tab

    you must be added here to the new disk .

    After sql server sees this new disk.

  6. Mehsah02, your a life saver. Thank you for mentioning this last requirement to finally get it to work.

  7. Yahoo.Com says:

    It seems u understand a good deal with regards to this issue and this shows as
    a result of this specific post, termed Motorized Window Shades “Adding a new disk to
    a SQL Server Cluster Instance | The SQL Herald”. Regards -Mandy

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s

%d bloggers like this: