"Neil Paddock" <NeilPaddock@discussions.microsoft.com> wrote in message
news:ABAE1437-F8EA-4E0F-829E-E26574538092@microsoft.com...
> Hi John,
>
> Still not with you - When I go to modify the dependencies of the SQL
> service, I see the following:
>
> Dependencies:
> CONT_DATA (Data disk)
> SQL Network Name
>
> Available Resources:
> Analysis Services
> SQL IP Address 1
> SQL Server Fulltext
>
> The Log disk is listed under the same cluster resource as the data disk.
>
> Thanks,
> Neil.
>
>
> "John Vandervliet" wrote:
>
> > Neil,
> >
> > ok I think you did that wrong, add the disks that are not showing up as
> > dedencies to the SQL server resource, you will need to stop the SQL
service
> > first then go to properties of the SQL Server service and modify the
> > dependencies tab so that each of the missing drives shows up under
Resource
> > Dependencies for the SQL Server Properties.
> >
> > That should do the trick.
> >
> > Use the following to see if SQL instance is actually seeing the drives.
> >
> > select * from ::fn_servershareddrives()
> >
> >
> > John Vandervliet..
> >
> >
> >
> > Open the cluster admin tool
> > "Neil Paddock" <NeilPaddock@discussions.microsoft.com> wrote in message
> > news:378CC919-885B-4C52-9167-6624799A23DE@microsoft.com...
> > >I have set the dependencies on the logs disk resource but still can't
see
> > >it
> > > under the database properties in SSMS?
> > >
> > > I have restarted cluster services on both nodes - is there anything
else I
> > > have missed?
> > >
> > > Thanks,
> > > Neil Paddock.
> > >
> > > "Geoff N. Hiten" wrote:
> > >
> > >> You must add the disks to the resource group for your SQL Server AND
make
> > >> the SQL service dependant on them.
> > >>
> > >> Once you have this configured, SQL will display and allow these disk
> > >> devices
> > >> to be used for database file storage.
> > >>
> > >> You can use SSMS to change the default location once the dependencies
are
> > >> set correctly.
> > >>
> > >> --
> > >> Geoff N. Hiten
> > >> Senior Database Administrator
> > >> Microsoft SQL Server MVP
> > >>
> > >>
> > >> "Neil Paddock" <NeilPaddock@discussions.microsoft.com> wrote in
message
> > >> news:E96CD8BB-AA4E-49EE-B454-14BFA1316805@microsoft.com...
> > >> >I am having difficulty setting up my disks on my SQL 2005 cluster.
I
> > >> >have
> > >> >a
> > >> > data disk and log disk for each instance (3) but when trying to
setup a
> > >> > new
> > >> > DB, when I try to choose the log drive it does not appear.
> > >> >
> > >> > I remember choosing a location during setup for data files and this
is
> > >> > what
> > >> > is displayed.
> > >> >
> > >> > How do I go about splitting my data and log files for each database
> > >> > instance?
> > >> >
> > >> > Thanks,
> > >> > Neil Paddock.
> > >>
> > >>
> >

"John Vandervliet" wrote:

> Neil,
>
> ok I think you did that wrong, add the disks that are not showing up as
> dedencies to the SQL server resource, you will need to stop the SQL service
> first then go to properties of the SQL Server service and modify the
> dependencies tab so that each of the missing drives shows up under Resource
> Dependencies for the SQL Server Properties.
>
> That should do the trick.
>
> Use the following to see if SQL instance is actually seeing the drives.
>
> select * from ::fn_servershareddrives()
>
>
> John Vandervliet..
>
>
>
> Open the cluster admin tool
> "Neil Paddock" <NeilPaddock@discussions.microsoft.com> wrote in message
> news:378CC919-885B-4C52-9167-6624799A23DE@microsoft.com...
> >I have set the dependencies on the logs disk resource but still can't see
> >it
> > under the database properties in SSMS?
> >
> > I have restarted cluster services on both nodes - is there anything else I
> > have missed?
> >
> > Thanks,
> > Neil Paddock.
> >
> > "Geoff N. Hiten" wrote:
> >
> >> You must add the disks to the resource group for your SQL Server AND make
> >> the SQL service dependant on them.
> >>
> >> Once you have this configured, SQL will display and allow these disk
> >> devices
> >> to be used for database file storage.
> >>
> >> You can use SSMS to change the default location once the dependencies are
> >> set correctly.
> >>
> >> --
> >> Geoff N. Hiten
> >> Senior Database Administrator
> >> Microsoft SQL Server MVP
> >>
> >>
> >> "Neil Paddock" <NeilPaddock@discussions.microsoft.com> wrote in message
> >> news:E96CD8BB-AA4E-49EE-B454-14BFA1316805@microsoft.com...
> >> >I am having difficulty setting up my disks on my SQL 2005 cluster. I
> >> >have
> >> >a
> >> > data disk and log disk for each instance (3) but when trying to setup a
> >> > new
> >> > DB, when I try to choose the log drive it does not appear.
> >> >
> >> > I remember choosing a location during setup for data files and this is
> >> > what
> >> > is displayed.
> >> >
> >> > How do I go about splitting my data and log files for each database
> >> > instance?
> >> >
> >> > Thanks,
> >> > Neil Paddock.
> >>
> >>