Add new disk to existing Sql server cluster

Question

Hi all

I've added new shared disks to SQL cluster resource. But I cannot access it on Sql Server? What's should I do?

Thank you for any suggestion

Answer 1

References:

How to Add a New Disk/Drive to SQL Server Failover Cluster?

Add Storage to a Failover Cluster

Adding Storage to SQL Server 2008 Cluster

---

---

Kalman Toth Database & OLAP/AI Architect SQL Server 2016 Database Design
New Book : Beginner Database Design & SQL Programming Using Microsoft SQL Server 2016

Answer 2

https://mssqltrek.com/2012/06/28/how-to-add-a-new-diskdrive-to-sql-server-failover-cluster/

---

Best Regards,Uri Dimant SQL Server MVP, http://sqlblog.com/blogs/uri_dimant/

MS SQL optimization: MS SQL Development and Optimization
MS SQL Consulting: Large scale of database and data cleansing
Remote DBA Services: Improves MS SQL Database Performance
SQL Server Integration Services: Business Intelligence

Answer 3

Thank you Kalman. I will try and report

Answer 4

there is no Drive  as dependency. Now you have to add the new drive as “AND” dependent as shown below and you are all set to go

Now see below Dependency report, where Drive  is no longer floating in the air

https://mssqltrek.com/2012/06/28/how-to-add-a-new-diskdrive-to-sql-server-failover-cluster/

---

Please click Mark As Answer if my post helped.

Answer 5

Maybe I misunderstand Dependency disk purpose and I have not configued it

Answer 6

Hi ,

Add Dependencies to a SQL Server Resource

We need to select the SQL Server resource. Open the Properties dialog box, and use the Dependencies tab to add the disk to the set of SQL Server dependencies.

In the below screenshot, I am selecting the SQL Server properties.

In the below screenshot, we have added the resource dependencies for clustered disk 14 and clustered disk 15.

We can check the dependency of SQL Server by selecting the show dependency report.

In the below screenshot, we can see the dependecy report for SQL Server resources.

http://www.sqlservercentral.com/articles/cluster/131554/

---

Please click Mark As Answer if my post helped.

Answer 7

To add a dependency to a SQL Server resource

• Open the Failover Cluster Manager snap-in.

• Locate the group that contains the applicable SQL Server resource that you would like to make dependent.

• If the resource for the disk is already in this group, go to step 4. Otherwise, locate the group that contains the disk. If that group and the group that contains SQL Server are not owned by the same node, move the group containing the resource for the disk to the node that owns the SQL Server group.

• Select the SQL Server resource, open the Properties dialog box, and use the Dependencies tab to add the disk to the set of SQL Server dependencies.

https://msdn.microsoft.com/en-us/library/ms177447.aspx

---

Please click Mark As Answer if my post helped.