My Favorite Blogs

Saturday, February 23, 2013

Msg 5184, Level 16, State 2, Line 1

Today I was working on one of the SQL instance on a four node cluster. There are 4 data drives which were mounted already and yesterday I imported 2 new drives (Data5 and 6) in the cluster, they are all mounted drives (Eg. D:\Data1, D:\Data2, where D:\ is a smaller size SAN on it mount all the required drives) The plan was to add new data files on the new drives and cap the existing filled drives to avoid SCOM drive free space alerts. When I tried to add new files on a database in the newly imported drives it didnt succeeded where as it thrown below errors.


Msg 5184, Level 16, State 2, Line 1
Cannot use file 'D:\Data5\SQLDBOps_data5.ndf' 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.
Msg 5009, Level 16, State 8, Line 1
One or more files listed in the statement could not be found or could not be initialized.

This error occurred due to the newly added drives are not dependencies of the SQL server resource in the cluster resource group. This error i encountered one ago so I just want to share in my blog it would help others too...

Here are the steps you have to do to fix it.

1. Go to Failover Cluster Manager --> Click on the correct SQL resouce group --> Right click on the SQL Resource --> Go to the Dependencies tab
2. Check the SQL Server resource decencies on the cluster resource group.Sure you wont find the newly imported drives in it.
3. Add the new driver(s) in the Resource column and click apply and then OK.
4. Repeat the step 3 if you need to add any more drives as SQL Server dependencies. Make sure all the Data,Log and TempDB drives are in the dependencies.

Once this is completed, I tried to add new files in the new data drives, which works without any errors.


Hope this helps...



1 comment:

  1. Thanks, it really helped me out.

    Regards,
    Pratik

    ReplyDelete