SQL Server - drive not visible in the SQL server

Asked By Julie

17-Apr-07 11:12 AM

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

17-Apr-07 11:18 AM

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

17-Apr-07 11:24 AM

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

17-Apr-07 12:12 PM

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