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

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 )

Google photo

You are commenting using your Google 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 )

Connecting to %s

This site uses Akismet to reduce spam. Learn how your comment data is processed.

%d bloggers like this: