2009
12.30

So I am trying to restore a database to a sql cluster instance. I’ve done this many time so it should go without a hitch. When I ran the restore script “Restore database myDbName.bak …. with move …” I was hit with the following error:

Msg 5184, Level 16, State 2, Server DBServer\myInstance, Line 1

Cannot use file ‘O:\Databases\myDbName.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.

Then I realizes that O: drive was recently added to the cluster. So I opened up my Cluster Administrator and checked the Resources. I right clicked “SQL Server (myInstance)” and clicked properties. Under the Dependencies tab, the O: Drive is missing in the “Resource dependencies:” box. So I take “SQL Server (myInstance)” offline, add the drives to the “Resource dependencies:” box and all is fine.

No Comment.

Add Your Comment