Add new disk to sql server 2008 cluster

We have gone through previous article that tells you, how to add new disk in Sql server 2005 cluster environment. Here you will see, step by step approach to add new disk in Sql server 2008 failover cluster environment. Steps are very much similar to sql server 2005 cluster. First thing you need to ask your SAN administrator to add disk into cluster so that it could be visible to you in Disk management.

Adding a new disk in windows server 2008 failover clustering

  1. Now go to Disk Management, Here you should see new disk that just now added by SAN administrator. If it is showing offline then right click on the disk and select Online.
  2. Right click on unallocated disk and select “New Simple Volume”.
  3. It will display “New Simple Volume Wizard”, Click on Next to proceed.
  4. You will see the following page. Choose a volume size and click on Next.
  5. Here assign drive letter from drop down list, you can also create a mount point on an existing disk or do not assign a drive letter.
  6. Format the volume using NTFS also label the disk with proper name to identify disk and perform a quick format. Click on Next.
  7. The disk should now be online and allocated.
  8. Go to Failover Cluster Manager and right click on Storage and select “Add a disk”.add disk using failover cluster manager
  9. Select the new disk and click on OK.
  10. Click on Storage, you should see your new disk under “Available Storage”

Now right click on the service or application to add the new disk to a service or application and select “Add Storage”. 

add storage to sql server 2008

 

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

cluster disk for sql server 2008

Click on Sql server, you can see the new disk under SQL Server.

Summary of storage using failover cluster manager

 

To confirm whether disk has been added in dependencies, click on sql server and go to services right click on sql server, select properties.

Summary of sql server properties

 

In sql server properties window, you can see two cluster disk 3 and disk 2 are listed.

Check dependencies for sql server properties

 

 

Leave a Reply

  

  

  


5 − = 4