Getting multiple drives on a sql 2005 clustered instance

We are trying to create a clustered instance on sql 2005 which is
sitting on a clustered OS having 5 SAN drives presented to it. When
setting up a flat instance, every drive is availabe to split up the
data, log and index amongst several LUNs. When creating a clustered db
instance, it seems only the install path is available. Is this simply
just the design, or is there a way I can have the other drives available
to divide i/o? From what I've seen so far, it seems only the LUN the
instance is installed on is the only one available to define index and
log path. Thanks!!
*** Sent via Developersdex http://www.codecomments.com ***
You have to make the SQL Server service dependant on the drives in cluadmin
and then restart SQL.
Jason Massie
www: http://statisticsio.com
rss: http://feeds.feedburner.com/statisticsio
"Michael Johnson" <michael.johnson@.sysix.com> wrote in message
news:uUUbYA5bIHA.5476@.TK2MSFTNGP02.phx.gbl...
> We are trying to create a clustered instance on sql 2005 which is
> sitting on a clustered OS having 5 SAN drives presented to it. When
> setting up a flat instance, every drive is availabe to split up the
> data, log and index amongst several LUNs. When creating a clustered db
> instance, it seems only the install path is available. Is this simply
> just the design, or is there a way I can have the other drives available
> to divide i/o? From what I've seen so far, it seems only the LUN the
> instance is installed on is the only one available to define index and
> log path. Thanks!!
> *** Sent via Developersdex http://www.codecomments.com ***
|||To expand what Jason said, you need to use Cluster Administrator (type
cluadmin at Run or command line to launch it) to: (1) add the disks as disk
resources, if not already done, (2) move these disk resources to the resource
group of the SQL Server instance that will use these disks, and (3) take the
SQL Server resource offline, add these disk resources as its dependencies,
and bring the SQL Server resource online. Now, execute the following query in
the SQL instance to see whether these disks can be used to place database
files:
select * from fn_servershareddrives()
You should not see these disks in the result list, and that means you can
now place database files of this SQL Server instance on them.
Linchi
"Michael Johnson" wrote:

> We are trying to create a clustered instance on sql 2005 which is
> sitting on a clustered OS having 5 SAN drives presented to it. When
> setting up a flat instance, every drive is availabe to split up the
> data, log and index amongst several LUNs. When creating a clustered db
> instance, it seems only the install path is available. Is this simply
> just the design, or is there a way I can have the other drives available
> to divide i/o? From what I've seen so far, it seems only the LUN the
> instance is installed on is the only one available to define index and
> log path. Thanks!!
> *** Sent via Developersdex http://www.codecomments.com ***
>