resource

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.

– Under Other Resources -> Right-click on the SQL Server Instance name -> click Take this resource offline – Under Please confirm action -> click Take SQL Server Instance offline – When the instance is offline -> Right-click on it and select properties -> click on Dependencies tab -> click the Insert botton -> click the drop-down botton and select the new disk -> click Ok – Right-click on the SQL Server Instance -> click Bring this resource online