Create databases in a cluster

I am trying to create a database but it failes when creating the log file.
Q:\ quorum drive
H:\data
I:\log
The message I get on the I:\
Cannot use file 'I:\Log\rentclicks_Log.ldf' for clustered server. Only
formatted files on which the cluster resource of the server has a dependency
can be used.
Msg 1802, Level 16, State 1, Line 1
CREATE DATABASE failed. Some file names listed could not be created. Check
related errors.
From the cluster admin tool:
Stop the SQL server service.
Move the I: drive into the SQL resource group.
Add the new disk resource as a dependency of the SQL Service.
Start the SQL Service.
Geoff N. Hiten
Senior Database Administrator
Microsoft SQL Server MVP
"SAM" <SAM@.discussions.microsoft.com> wrote in message
news:04407CD9-0DC4-4859-9546-B1F461955ADE@.microsoft.com...
>I am trying to create a database but it failes when creating the log file.
> Q:\ quorum drive
> H:\data
> I:\log
> The message I get on the I:\
> Cannot use file 'I:\Log\rentclicks_Log.ldf' for clustered server. Only
> formatted files on which the cluster resource of the server has a
> dependency
> can be used.
> Msg 1802, Level 16, State 1, Line 1
> CREATE DATABASE failed. Some file names listed could not be created. Check
> related errors.
|||Thanks that worked. A outside source configured the Windows Cluster so I am
learning as I go in working with clustering.
"Geoff N. Hiten" wrote:

> From the cluster admin tool:
> Stop the SQL server service.
> Move the I: drive into the SQL resource group.
> Add the new disk resource as a dependency of the SQL Service.
> Start the SQL Service.
> --
> Geoff N. Hiten
> Senior Database Administrator
> Microsoft SQL Server MVP
>
> "SAM" <SAM@.discussions.microsoft.com> wrote in message
> news:04407CD9-0DC4-4859-9546-B1F461955ADE@.microsoft.com...
>
>
|||Not to put too fine a point on it, but if your consultant didn't include
training, then someone screwed up. Whether it was the consultant who didn't
do the training or your company who didn't insist on it is not important.
The important thing is you have a system you cannot support. That kind of
kills the whole "high availability" reason for a cluster in the first place.
Just my opinion.
Geoff N. Hiten
Senior Database Administrator
Microsoft SQL Server MVP
"SAM" <SAM@.discussions.microsoft.com> wrote in message
news:FAE23EF2-929B-442A-98B1-C7CD191F4185@.microsoft.com...[vbcol=seagreen]
> Thanks that worked. A outside source configured the Windows Cluster so I
> am
> learning as I go in working with clustering.
> "Geoff N. Hiten" wrote:
|||The company didn't insist. Myself and the system admin were support to
closely work with Dell when implementing the Windows cluster but there was
some confusion on who was do what and the training got left to the waist
side.
So I left to train myself and seek advice from experienced cluster
professionals. Thanks for your help.
"Geoff N. Hiten" wrote:

> Not to put too fine a point on it, but if your consultant didn't include
> training, then someone screwed up. Whether it was the consultant who didn't
> do the training or your company who didn't insist on it is not important.
> The important thing is you have a system you cannot support. That kind of
> kills the whole "high availability" reason for a cluster in the first place.
> Just my opinion.
> --
> Geoff N. Hiten
> Senior Database Administrator
> Microsoft SQL Server MVP
>
>
> "SAM" <SAM@.discussions.microsoft.com> wrote in message
> news:FAE23EF2-929B-442A-98B1-C7CD191F4185@.microsoft.com...
>
>
|||Dell is notorious for plug -n- play -n- leave. Unless you contracted for
specific training classes, the implementation consultants usually don't go
out of their way to teach. Not their fault, they are under severe time
pressure to get the systems up and move on.
If you can find a place teaching the MS course 2788, Designing High
Availability Database Solutions using Microsoft SQl Server 2005, I would
advise signing up. I am very familiar with that course and it should cover
exactly what you need.
Geoff N. Hiten
Senior Database Administrator
Microsoft SQL Server MVP
"SAM" <SAM@.discussions.microsoft.com> wrote in message
news:AB66AB78-6AD8-46AB-9210-719A1C18CB17@.microsoft.com...[vbcol=seagreen]
> The company didn't insist. Myself and the system admin were support to
> closely work with Dell when implementing the Windows cluster but there was
> some confusion on who was do what and the training got left to the waist
> side.
> So I left to train myself and seek advice from experienced cluster
> professionals. Thanks for your help.
>
> "Geoff N. Hiten" wrote: