Home Forums SQL Server 2005 Administering After having moved a .mdf when SSMS would not start RE: After having moved a .mdf when SSMS would not start

  • I had a chance to try to let the master files know that the database is moved, but things are complicated by the fact that the drives where the files are located are clustered.

    I had tried moving the .mdf file to a cluster disk that should be associated with another instance of sql server on the same box and tried moving it to the local disk but both gave me the same message:

    Cannot use file 'C:\datatel\data\ActiveCampusTest.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.

    I was thinking I could add the cluster disk as a dependency of this server instance, but I'm not sure if that's possible since the cluster disk is already part of another instance. The other option I was thinking was to move the entire database to another instance. Any ideas where I should go next?