SQL 2012: System.Data.SqlClient.SqlError: Cannot use file ” 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. (Microsoft.SqlServer.SmoExtended)

I presented a new lun to the sql server 2012 cluster and tried to restore a database to the new storage. I got the below error:

“System.Data.SqlClient.SqlError: Cannot use file ” 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. (Microsoft.SqlServer.SmoExtended)”

To resolve this I had to go to the Failover cluster  manager –>services and applications–>SQLServer (MS SQLServer) (highlight it) and in the Other resources select the SQL Server services–> Right click –> Properties–>Dependencies–>Insert (select the drive that you needs to be added or the ones that you presented to the cluster).This fixed the error.

Hope this helps!

 

Advertisements
This entry was posted in SQL Server DBA Stuff and tagged , . Bookmark the permalink.

2 Responses to SQL 2012: System.Data.SqlClient.SqlError: Cannot use file ” 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. (Microsoft.SqlServer.SmoExtended)

  1. Pingback: Error while trying to restore SQL database to a cluster | The Full Circle

  2. MoonLightDBA says:

    Screenshots are not necessary as long as description is clear.

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