Adding Storage to SQL Server 2008 Cluster

By:   |   Comments (12)   |   Related: > Clustering


I'm running out of disk space on my SQL Server 2008 cluster and need to add a new storage device. How can I accomplish this task?


Adding a new storage device using Windows 2008 Failover Clustering has been simplified enormously since the Windows 2003 and older clustering technology. In this tip, I'll show you how to add an extra storage device to your configuration. First thing you will need to do is get your SAN administrator to present a new disk to the cluster. Once the new disk is presented, go to Disk Management, and you should see the new disk unallocated. If the disk displays "Offline" simply right click and choose Online.


Next, right click on the disk and choose "New Simple Volume". Clustering does not support any of the other volume options.


After clicking "New Simple Volume" a wizard will appear.


Click Next and you will see the following page. Choose your volume size and click Next.


Choose a drive letter, create a mount point on an existing disk or do not assign a drive letter. In this example, I'll give the disk a drive letter of F. Click Next.


On this screen, you will need to format the volume using NTFS and you can rename the volume to better identify it later on. I will also perform a quick format. Click Next and Finish to format.


The disk should now be online and allocated.


Next, go to Failover Cluster Manager and right click on Storage and select "Add a disk".


The following window should appear. Select the new disk and click OK.


On the Summary of Storage page you should now see your new disk under "Available Storage"


To add the new disk to a service or application, right click on the service or application you need and select "Add Storage". In this example, I'll add the disk to SQL Server (HCM).


The Add Storage window will appear. Click on the drive and click OK.


On the Summary of Storage page you should now see the new disk under SQL Server (HCM)

Next Steps

sql server categories

sql server webinars

subscribe to mssqltips

sql server tutorials

sql server white papers

next tip

About the author
MSSQLTips author Brady Upton Brady Upton is a Database Administrator and SharePoint superstar in Nashville, TN.

This author pledges the content of this article is based on professional experience and not AI generated.

View all my tips

Comments For This Article

Sunday, June 23, 2019 - 12:02:56 AM - Manish Back To Top (81557)

You forgot to add dependency of sql server resource over new drive. Failing which it'll leave db in suspect mode

Wednesday, October 17, 2018 - 8:01:30 AM - Miguel Jurado Back To Top (77970)

 I complete All the steps. Unfortunately SQLServer Management Studio 2014 doesn´t show me the new drive letter when I want to choose a new destination for backup. Any help?


Friday, August 18, 2017 - 2:21:40 PM - Ashish Back To Top (65009)

Thanks ! this worked for me,.. 


Wednesday, July 9, 2014 - 1:26:05 PM - Ankit Shah Back To Top (32610)

Hi Brady ,

  This is very nice with detailed explanation and  helpful tip again. 

Just like to ask quick question regarding to this . I was configuring shared volumes for cluster  in windows server 2012 R2 and it was asking for Partition Style to select. GUID Partition Table ( GPT) or Master Boot Record (MBR). Any thought on this to select for SQL cluster shard voulems? 

Should I more concern about this or just go with defaults? 

Thanks again.

Wednesday, April 30, 2014 - 4:01:01 AM - Wahid Khan Back To Top (30555)

Hi, Very well explain... thank you very much for sharing.....




Wednesday, November 28, 2012 - 5:36:40 PM - Sik Back To Top (20610)

Hello Brad,

Thank you for the article. I have a quick question while adding new storage to the Windows 2008 R2 cluster.

I have an A/A/A/P cluster and i am trying to add new storage to first node. The new disk has been presented to the OS and i can see it on node 1 under disk managment. The 2 new disks are numbered as 26,27 and has 300 & 200 GB of capacity, but when i check the same disk(26 & 27) from other nodes(2 & 3) via the disk managment, it shows the wrong storage capacity i.e for 27 is shows 300 where as for 26 ot shows 200. Is this normal or is it something i need to be worried about?

Note at this moment these disks are still offline and not yet added in the cluster.

Thursday, October 18, 2012 - 12:34:08 PM - vijay ahire Back To Top (19981)


Hi,Kindly let me know "What is the difference between Active/Active and Active/Passive" clustering??

Thursday, September 27, 2012 - 9:52:29 AM - venushakamuri Back To Top (19707)


Wednesday, May 16, 2012 - 9:41:18 AM - Devi Prasad Back To Top (17484)

Ohh!! this really so easy to add a storage to Cluster.. Nice explanation with screenshot.. Thank u Brady :)

Monday, May 14, 2012 - 10:10:45 AM - Tim Back To Top (17451)


Very nice article. I would add that for sql server, for ultimate peformance, and for drives that will only hold SQL Server database files, that when you come to the screen "Format the volume", change the Allocation Unit size from the default  (default is 4KB) to 64 KB.  The drawback to this is if you put a number 1 KB batch files here, you will really chew up disk space. However, sql server will perform better with 64KB allocation units.

 Reference: Pro SQL Server 2008 Failover Clustering  By Allan Hirt Chapter 3, page 95.



Monday, May 14, 2012 - 9:16:36 AM - Maneesh Bhatt Back To Top (17450)

Thanks for the nice article...

Monday, May 14, 2012 - 7:14:18 AM - Kumar Back To Top (17448)

Thanks Brady for wonderful Article. This will really help the DBA's working on Cluster Server and face issues with Disk Space .


Best Regards,


get free sql tips
agree to terms