none
Add new disk to existing Sql server cluster RRS feed

  • 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

    Sunday, October 30, 2016 7:41 AM

All replies

    • Edited by Kalman Toth Sunday, October 30, 2016 7:48 AM
    • Proposed as answer by PrinceLucifer Wednesday, November 2, 2016 6:19 AM
    Sunday, October 30, 2016 7:46 AM
  • 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

    Sunday, October 30, 2016 7:47 AM
  • Thank you Kalman. I will try and report
    Sunday, October 30, 2016 7:57 AM
  • 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.

    Sunday, October 30, 2016 8:37 AM
  • Maybe I misunderstand Dependency disk purpose and I have not configued it
    Sunday, October 30, 2016 8:45 AM
  • 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.


    • Edited by Times Decides Sunday, October 30, 2016 8:47 AM picture
    Sunday, October 30, 2016 8:47 AM
  • 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.

    Sunday, October 30, 2016 9:00 AM