Recently I was trying to restore 100 databases into a newly provisioned shared clustered disks and ran into this error message using Commvault: [code language=”SQL”] ERROR CODE: Query Result [Cannot use file ‘G:\Data\database1.mdf’ for clustered server. Only formatted files on which the cluster resource of the server has a dependency can be used. Either the disk resource containing the file is not present in the cluster group or the cluster resource of the Sql Server does not have a dependency on it.
In this post I will work you through on how to add new disk as a resource and dependency to an existing cluster group. Key requirement will be to ensure that a new disk/LUN had been provisioned and added as new drives to the SQL servers. Also ensure that the disk is formatted with the appropriate Allocation Unit Size. Refer to this Post for more details. Installation Steps – Log in to the active cluster node - Open the Failover Cluster Manager - Navigate down to Storage - Right-click on Storage and click Add a disk – On Add Disks to a Cluster - Ensure the new disk is selected - click OK – The cluster manager will add the new disk and bring it online – When the disk is added, you will notice under Available Storage the newly added disk.