How to add a Physical Disk Resource to the SQL Cluster Group?

Uncategorized 1 Minute

After you added a physical disk resource to the SQL cluster group, if you don’t see your drive in SQL management studio (console), you should know that you need to add the new physical disk as dependency to the SQL service.

When you get this error message upon adding the disk as dependency, this blog solution is for you.

image

The error message means you have to make SQL service offline and add the dependency. Follow the steps below to make that happen:

  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 the SQL Server resource offline.

  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.

Keywords: An Error occurred attempting to add ‘drive’ as dependency of ‘SQL Server’. The operation could not be completed because the cluster resource is online. Error ID: 5019 (0000139b)

Published by --Anand--

Being in Silicon Valley for years, I became a IT Infrastructure Geek by experience and surrounded by other Geeks everywhere. I try to help others by the solutions I found on odd occasions.

Published

One thought on “How to add a Physical Disk Resource to the SQL Cluster Group?”

  1. This will bring the SQL server down? Do I need to do this OOH?
    Whats the effect of bringing the sql server resource offline?

    Reply

Leave a comment