Adding Disks

I would like to add another volume to my two node sql 2005 cluster. From
what i have been reading i need to shut one of the cluster nodes, add
the drive to the cluster then bring the backup node back on line. Am i
missing anything?
Thanks for the help
Noah Hamilton
Sr Systems Administrator
Carpathia Hosting, Inc
21711 Filigree Court, Suite A
Ashburn, VA 20147
voice: (703) 297-4451
Fax: (703) 997 5577
www.carpathiahost.com
Once you have physically connected the disk (or carved a new LUN and
presented it to the host computers), you must create a clustered resource.
Use the cluster admin tool to create a disk resource and map it to the
physical disk. I usually create a temporary resource group to park it in
while I am setting things up. Test failover to make sure all host nodes can
"see" and use the clustered disk.
You then can move the disk into the SQL resource group. Finally, you must
make the SQL Service dependent on the new disk before SQL will use it for
data or logs. This will require stopping the SQL service while the
dependencies are changed.
Geoff N. Hiten
Senior SQL Infrastructure Consultant
Microsoft SQL Server MVP
"Noah" <noah@.carpathiahost.com> wrote in message
news:%23$wrjlp2HHA.4584@.TK2MSFTNGP03.phx.gbl...
>I would like to add another volume to my two node sql 2005 cluster. From
>what i have been reading i need to shut one of the cluster nodes, add the
>drive to the cluster then bring the backup node back on line. Am i missing
>anything?
> Thanks for the help
> Noah Hamilton
> Sr Systems Administrator
> Carpathia Hosting, Inc
> 21711 Filigree Court, Suite A
> Ashburn, VA 20147
> voice: (703) 297-4451
> Fax: (703) 997 5577
> www.carpathiahost.com
>
|||Thanks for the help. I have the new drives up and running now.
Appreciate all the help.
Geoff N. Hiten wrote:
> Once you have physically connected the disk (or carved a new LUN and
> presented it to the host computers), you must create a clustered
> resource. Use the cluster admin tool to create a disk resource and map
> it to the physical disk. I usually create a temporary resource group to
> park it in while I am setting things up. Test failover to make sure all
> host nodes can "see" and use the clustered disk.
> You then can move the disk into the SQL resource group. Finally, you
> must make the SQL Service dependent on the new disk before SQL will use
> it for data or logs. This will require stopping the SQL service while
> the dependencies are changed.
>

adding disk to existing clustered sql 2000 instance

hi guys
i had 2 sql instances in win2003. I uninstalled one instance. How do i add
the disks to the existing/active instance?
TIAHi
Move the disks to the SQL Server group you want to add them to. Take the
group offline, create a dependency for SQL Server on the new disks and bring
the group online again.
Regards
--
Mike Epprecht, Microsoft SQL Server MVP
Zurich, Switzerland
MVP Program: http://www.microsoft.com/mvp
Blog: http://www.msmvps.com/epprecht/
"rupart" wrote:

> hi guys
> i had 2 sql instances in win2003. I uninstalled one instance. How do i add
> the disks to the existing/active instance?
> TIA|||hi Mike,
i tried to create the resource(physical disk) but couldnt see the disks
under the list...
"Mike Epprecht (SQL MVP)" wrote:
[vbcol=seagreen]
> Hi
> Move the disks to the SQL Server group you want to add them to. Take the
> group offline, create a dependency for SQL Server on the new disks and bri
ng
> the group online again.
> Regards
> --
> Mike Epprecht, Microsoft SQL Server MVP
> Zurich, Switzerland
> MVP Program: http://www.microsoft.com/mvp
> Blog: http://www.msmvps.com/epprecht/
>
> "rupart" wrote:
>

adding disk to existing clustered sql 2000 instance

hi guys
i had 2 sql instances in win2003. I uninstalled one instance. How do i add
the disks to the existing/active instance?
TIA
Hi
Move the disks to the SQL Server group you want to add them to. Take the
group offline, create a dependency for SQL Server on the new disks and bring
the group online again.
Regards
Mike Epprecht, Microsoft SQL Server MVP
Zurich, Switzerland
MVP Program: http://www.microsoft.com/mvp
Blog: http://www.msmvps.com/epprecht/
"rupart" wrote:

> hi guys
> i had 2 sql instances in win2003. I uninstalled one instance. How do i add
> the disks to the existing/active instance?
> TIA
|||hi Mike,
i tried to create the resource(physical disk) but couldnt see the disks
under the list...
"Mike Epprecht (SQL MVP)" wrote:
[vbcol=seagreen]
> Hi
> Move the disks to the SQL Server group you want to add them to. Take the
> group offline, create a dependency for SQL Server on the new disks and bring
> the group online again.
> Regards
> --
> Mike Epprecht, Microsoft SQL Server MVP
> Zurich, Switzerland
> MVP Program: http://www.microsoft.com/mvp
> Blog: http://www.msmvps.com/epprecht/
>
> "rupart" wrote: