Learn more about SQL Server tools

mssqltips logo
 

Tutorials          DBA          Dev          BI          Career          Categories          Webcasts          Whitepapers          Today's Tip          Join

Tutorials      DBA      Dev      BI      Categories      Webcasts

DBA    Dev    BI    Categories

 

Adding Storage to SQL Server 2008 Cluster


By:   |   Last Updated: 2012-05-14   |   Comments (11)   |   Related Tips: More > Clustering

Problem

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?

Solution

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.

DiskManagement

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

AddSimpleVolume

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

SimpleVolumeWizard

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

VolumeSize

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.

DriveLetter

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.

Format

The disk should now be online and allocated.

DiskManagement2

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

AddDisk

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

AddStorage1

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

StorageSummary

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).

AddStorage2

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

AddStorage3

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

StorageSummary2
Next Steps


Last Updated: 2012-05-14


next webcast button


next tip button



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

View all my tips
Related Resources




Post a comment or let the author know this tip helped.

All comments are reviewed, so stay on subject or we may delete your comment. Note: your email address is not published. Required fields are marked with an asterisk (*).

*Name    *Email    Email me updates 


Signup for our newsletter
 I agree by submitting my data to receive communications, account updates and/or special offers about SQL Server from MSSQLTips and/or its Sponsors. I have read the privacy statement and understand I may unsubscribe at any time.



    



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

 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

Thanks ! this worked for me,.. 

 


Wednesday, July 09, 2014 - 1:26:05 PM - Ankit Shah Back To Top

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

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

 

Regards

Wahid


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

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

 

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

Nice!!!!!!!!!!


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

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

 

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.

http://books.google.com/books?id=llBzeSu_UmYC&pg=PA95

 

 


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

Thanks for the nice article...


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

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

 

Best Regards,

Kumar


Learn more about SQL Server tools