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. This
will require taking SQL offline when making the change.
Geoff N. Hiten
Senior Database Administrator
Microsoft SQL Server MVP
"Julien" <Julien@.discussions.microsoft.com> wrote in message
news:84B592EF-FD04-447B-8456-25ABE59E6FF1@.microsoft.com...
> 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
>
|||Hi Geoff,
Thanks a lot for your reply.
It's definitely making sens to me but I'm not sure how to do this.
Could you please l explain a bit further?
Thanks,
Julien
"Geoff N. Hiten" wrote:

> 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
>
>
> "Julien" <Julien@.discussions.microsoft.com> wrote in message
> news:84B592EF-FD04-447B-8456-25ABE59E6FF1@.microsoft.com...
>
|||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
"Julien" wrote:
[vbcol=seagreen]
> Hi Geoff,
> Thanks a lot for your reply.
> It's definitely making sens to me but I'm not sure how to do this.
> Could you please l explain a bit further?
> Thanks,
> Julien
> "Geoff N. Hiten" wrote:

Drill-down using "n" levels using a table?

How should i create a "n" levels drill-down report using a table based on MDX query?

I can only seem to use the visible or invisible based on a know number of levels ("columns in the table") what if i don't know that exact number? Or it is a unbalanced hierarchy?

I cannot use the Matrix because my columns are static and with two levels...

You can use show/hide recursive groups in a table based on parent child hierarchies.|||How do i use that option in SSRS 2005 ?