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


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)

Advertisements

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?

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s