When we are trying to create a database on newly added disk in SQL server instance. They came with below error. This error usually come if database you are creating is using some drive which is not added in dependency list in Cluster SQL service. Below is the error.
Cannot use file 'X:\DATA\xxxxx.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.
Solution:
1. Open the failover manager.
2. Verify the newly added disk is added to the instance group or not. If not, then right click on disk and select 'more acitions' and then select 'move this resource to another resource or application'
3. Right click on SQL server instance service and select Properties.
4. Go to dependency TAB, in that add the disk here and click OK button.
5. Next try to create database. It works...:)
Cannot use file 'X:\DATA\xxxxx.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.
Solution:
1. Open the failover manager.
2. Verify the newly added disk is added to the instance group or not. If not, then right click on disk and select 'more acitions' and then select 'move this resource to another resource or application'
3. Right click on SQL server instance service and select Properties.
4. Go to dependency TAB, in that add the disk here and click OK button.
5. Next try to create database. It works...:)
nice post SQL Server DBA Online course Bangalore
ReplyDeleteThank you!
DeleteThanks for sharing this post.Your post is really very helpful its students.SQL server DBA online training
ReplyDelete