About Me

Barking, Essex, United Kingdom
MCITP DBA ,MCITP BI & Oracle OCP 11G

Tuesday, August 18, 2015

Adding disk cluster dependency to sql server

To add a dependency to a SQL Server resource

  1. Open the Cluster Administrator in Windows Administrative Tools.
  2. Locate the group that contains the applicable SQL Server resource that you would like to make dependent.
  3. 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.
  4. Bring the SQL Server resource offline. This step applies to Windows 2003 failover clusters. Windows 2008 clusters do not require this step.
  5. 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


once the disk successfully added to the sql server dependencies , it will be available in the sql server and also we can verify in the below dependency report.




No comments:

Post a Comment