SQL Server 2005 SP2 on a cluster node with two members. OS is Windows 2003 Server SP2. This the production environment. Test environment is not clustered.
On the Cluster Administrator/Groups there are 2 groups defined for instances. Need to create db on an instance which has a group with 3 physical drives, U, V and W. When trying to create a new database the default location for data and log files uses the U drive by default. If I overwrite the file location to use the V drive for the log file to separate data and log file locations, the following error is displayed :
" Cannot use file 'V:\..\..' 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. Create Database Failed. Some files names listed could not be created. Check related errors.(Microsoft SQL Server, Error: 5184)"
The disk dive V is past of the group for that instance so do I need to create dependencies among the physical disks for this particular group?