To add a dependency to a
SQL Server resource
- Open the Cluster
Administrator in Windows Administrative Tools.
- 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.
- Bring the SQL Server
resource offline. This step applies to Windows 2003 failover
clusters. Windows 2008 clusters do not require this step.
- 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