AX Consulting

Just another WordPress.com site

Add a new disk to a SQL Server 2008 R2 Failover Cluster (running on Windows Server 2008 R2)

Imparted from

Follow up the following 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

Advertisements

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 )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s

%d bloggers like this: