2005 Cluster unable to add new database

SQLServerCentral is supported by Red Gate Software Ltd.

Popular Topics

Home

Members

Calendar

Who's On

Home » SQL Server 7,2000 » In The Enterprise » 2005 Cluster unable to add new database

2005 Cluster unable to add new database

Rate Topic

Display Mode

Topic Options

Author

Message

Solon

Posted Monday, August 20, 2012 8:54 AM

Forum Newbie

Group: General Forum Members
Last Login: 2 days ago @ 12:26 PM
Points: 4, Visits: 75

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

Post #1347248

Solon

Posted Wednesday, August 22, 2012 3:00 PM

Forum Newbie

Group: General Forum Members
Last Login: 2 days ago @ 12:26 PM
Points: 4, Visits: 75

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.

Post #1348758

Steve Jones - SSC Editor

Posted Wednesday, August 22, 2012 3:20 PM

SSC-Dedicated

Group: Administrators
Last Login: Today @ 11:20 AM
Points: 31,437, Visits: 13,752

Glad you figured it out and thanks for the update.

Follow me on Twitter: @way0utwest

Forum Etiquette: How to post data/code on a forum to get the best help

Post #1348769

« Prev Topic | Next Topic »

Permissions