drive not visible in the SQL server

Hi all,

Here is my problem:
I've having trouble to make my second logical drive available for database
under SQL server 2005 (Other words: I cannot move database to my second
database drive because I cannot see it in SQL server 2005)

Config:
- Cluster Acitve/passive
- 2 nodes (Win 2003 server SE SP2)
- 4 drives configured:
* drive 1 for quorum
* drive 2 for fro tempdb
* drive 3 for my database (old) and logs
* drive 4 for my database (where I want to move to)
- SQL server 2005 SP1


This new drive is properly configured (or so I think) in the cluster admin,
as a physical drive part of my SQLserver Data group resource (as my old drive
is) and is showing up active in my resource list.
I can also browse it as normal from Windows

When trying to move the database in SQL server 2005, I can only browse my
current database drive and I cannot see the new one.

Any ideas what am I missing ?

Thanks a lot for your help.

Julien

You have to make the SQL service dependant on the new drive resource.

You have to make the SQL service dependant on the new drive resource.  This
will require taking SQL offline when making the change.

--
Geoff N. Hiten
Senior Database Administrator
Microsoft SQL Server MVP

Hi Geoff,Thanks a lot for your reply.

Hi Geoff,

Thanks a lot for your reply.
it is definitely making sens to me but I am not sure how to do this.
Could you please l explain a bit further?

Thanks,

Julien

After a bit of diggin, I found and corrected the options.

After a bit of diggin, I found and corrected the options.
Located in the SQLserver ressource of the cluster, once put offline, just
added the correct dependencies.

Thanks a lot for the Geoff.

Julien