How to add a new disk to a SQL Server Failover Cluster


When you need to add a new disk to a SQL Server 2008 R2 Failover Cluster (running on Windows Server 2008 R2), you just need to follow this steps:

 

1. Configure your SAN to present your disks to the Cluster Servers.

2. Detect the new disk’s at Windows Storage Manager (on both servers):

image

 

3. Add this new this to the cluster Service (Go to Server Manager –> Features –> Failover Cluster Manager –> Storage –> Right Click and click Add a Disk):

image

 

4. Go to Failover Cluster Manager –> Services and Applications, and right click SQL Server and then select “Add storage”:

image

 

5. Now it’s important, after the step 4 you can see the disk at cluster service associated to the SQL Server Service, but at SQL Server Manager, you can’t see the disk! So, you just need to add service dependence:

Right Click SQL Server Resource, and click Properties:

image

Click on Dependencies Tab, and then click on the last line to add a new line, and select “AND” and then select the new disk resource:

image

image

Now click Apply and OK and the new disk is now available to the SQL Server Service!

image

 

Don’t forget to click like (FB) or share this post Piscar de olho

Advertisements

SQL SERVER – 2008 – Step By Step Installation Guide


I have created this step by step guide Installation Guide. Images are used to explain the process easier.

[Click On Images to See Larger Image]

%d bloggers like this: