Hello every one, We have facing the issue when we are adding the disk to sqlclustering Senario # Iniatlly SQL Cluster was build with 1 Drive and now after building the cluster we need to add 5 more disk to same cluster. We have added those disk in Window clustering and same we added those disk in our SQL resource But when we create\Restore any database with new file location it give the error Can not use "Drive path" for cluster server . Only Formatted file on which the cluster resource has dependecy can be user How can we check that the disk is dependended on Cluster resource
You did not mention what version of SQL Server. I am going to provide feedback based on SQL Server 2008R2. Open The Failover Cluster Manager. Expand the tree locating Services and applications Expand Services and applications Choose the instance you added the new disks as a resource In the summary window you should have several sections Server Name Disk Drives Other Resources -SQL Server -SQL Server Agent Right click on the SQL Server and choose properties It should open a new window. Under the "Dependencies" tab make sure the new drives are added as a resource here.