2005 Cluster unable to add new database

  • Solon

    SSC Enthusiast

    Points: 164

    I have a 2 node windows 2003 cluster with SQL Server 2005 running. The first node is the owner of SQL which has dependencies on the D: (Data), E: (index), F: (Log), H: (TempDB), and T: (Backup) drives. We have one database running with the files distributed across these volumes. We are trying to add another database but when I go to add it it gives me the following error:

    Cannot use file 'D:\MSSQL.1\MSSQL\Data\test.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.

    The database that runs on the cluster is located in the same location, so we know that it can see that resource and the SQL cluster group has the drive as a dependency. Any ideas?

    Image of SQL dependencies: http://imgur.com/s1bf5

  • Solon

    SSC Enthusiast

    Points: 164

    This wound up being an issue with the D: dependency. The original configuration was changed at one point to add a new, larger volume which replaced the old D: but the dependency was still pointing to the old drive. this is because the old drive was still in existence but had the drive letter changed. Once I added a new resource for the correct volume and added it to the sql server as a dependency i was able it resolved the issue.

  • Steve Jones - SSC Editor

    SSC Guru

    Points: 714105

    Glad you figured it out and thanks for the update.

Viewing 3 posts - 1 through 3 (of 3 total)

You must be logged in to reply to this topic. Login to reply