Friday, February 24, 2012

add disk to a cluster running sql2005

hi,
I have a windows 2003 sp1 cluster running sql2005.
the DB is installed on S: and i have a R: & U: drive letter that is both
differend disk and runs fine in the cluster.
But i can not see those disks in sql 2005 why ?
the disks are in the same resource group (SQL)
where can I choose the R drive ?
if I choose attach DB I see only the S drive where the DB is installed.
any help is welcome
greetings,
Robert
Hi,
Just fixed it
I added the disk resources to the SQL2005 server resource and now it is
running.
greetings,
"Robert Smit ( 450331)" <RSM.news@.thebackbone.nl> wrote in message
news:OeiQZhQFGHA.524@.TK2MSFTNGP09.phx.gbl...
> hi,
> I have a windows 2003 sp1 cluster running sql2005.
> the DB is installed on S: and i have a R: & U: drive letter that is both
> differend disk and runs fine in the cluster.
> But i can not see those disks in sql 2005 why ?
> the disks are in the same resource group (SQL)
> where can I choose the R drive ?
> if I choose attach DB I see only the S drive where the DB is installed.
> any help is welcome
> greetings,
> Robert
>
|||Just adding them to the SQL Server group is not enough. They have to be
added as a dependency of the SQL Server resource.
Mike
Mentor
Solid Quality Learning
http://www.solidqualitylearning.com
"Robert Smit ( 450331)" <RSM.news@.thebackbone.nl> wrote in message
news:OeiQZhQFGHA.524@.TK2MSFTNGP09.phx.gbl...
> hi,
> I have a windows 2003 sp1 cluster running sql2005.
> the DB is installed on S: and i have a R: & U: drive letter that is both
> differend disk and runs fine in the cluster.
> But i can not see those disks in sql 2005 why ?
> the disks are in the same resource group (SQL)
> where can I choose the R drive ?
> if I choose attach DB I see only the S drive where the DB is installed.
> any help is welcome
> greetings,
> Robert
>

No comments:

Post a Comment