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.File ‘database1’ cannot be restored to ‘G:\Data\database1.mdf’. Use WITH MOVE to identify a valid location for the file.Cannot use file ‘G:\Data\database1.ldf’ for clustered server.
[/code]
It appears if you attempt to create/move a database(s) on another shared cluster drive when the SQL Server resource is not dependant on that disk, you tend to receive the above error or other similar errors as documented by Microsoft.
Steps needed to fix this:
– Open the Cluster Administrator via Administrative Tools
– Click on Storage and ensure the new disk is in the same group as the SQL Server resource and Online
– Expand Services and applications, click on your clustered application (in my case is the default SQL Server (MSSQLSERVER)), right-click the SQL Server resource, and then click Properties
– Click the Insert button to add an additional row, then select the new shared disk that will contain your SQL databases
– Ensure that all resources required are present and then click OK to save the changes