Adding Spindals on Cluster to SAN

How much work is it to add spindals to a drive on a
Windows 2000 Advanced Server clustered on a SAN?
Thank You,
Dave
You will need Veritas volume manager to expand the logical drive at the OS
level under Windows 2000. What happens at the SAN level depends on your SAN
vendor.
Geoff N. Hiten
Microsoft SQL Server MVP
Senior Database Administrator
Careerbuilder.com
I support the Professional Association for SQL Server
www.sqlpass.org
"Dave" <anonymous@.discussions.microsoft.com> wrote in message
news:59bf01c42d50$5c2ec8a0$a301280a@.phx.gbl...
> How much work is it to add spindals to a drive on a
> Windows 2000 Advanced Server clustered on a SAN?
> Thank You,
> Dave
|||Dave -
Because we don't use Veritas we generally just add another drive to the
cluster, and make sure that the new drive does not share any spindals with
the old drive on the SAN. Then we just balance our data files.
Craig
ccarl@.mcafee.com
"Dave" <anonymous@.discussions.microsoft.com> wrote in message
news:59bf01c42d50$5c2ec8a0$a301280a@.phx.gbl...
> How much work is it to add spindals to a drive on a
> Windows 2000 Advanced Server clustered on a SAN?
> Thank You,
> Dave
|||If you wish to add physical disks to the same volume presented to your nodes in the cluster, assuming your SAN vendor supports it:
1. Add the new disks to the disk pool
2. Use diskpart (from the W2K resource kit - it comes with the o/s in W2K3) to "list volume" then "select volume" x and then "extend" the partition.
Note1: You must use diskpart 5.1 or newer (some of the earlier versions are dodgy)
Note2: This is an on-line operation and causes no disruption to current SQL operations.

Adding drive dependencies to WIN2k/SQL2k cluster resource

I need to add two additional SAN attached volumes to be dependencies
for my SQL Server Cluster resource. Do I have to restart the cluster
service for this to take affect? Is there another way for the cluster
resource to re initialize it's dependencies without restarting?
If you want to create databases on these drives, you need to add them to the
SQL Server resource dependency list. To do that, you don't need to restart
the cluster service. But you do need to take the SQL Server resource offline,
add the drives as the dependencies, and then bring the SQL Server resource
online.
Linchi
"zoneranger@.gmail.com" wrote:

> I need to add two additional SAN attached volumes to be dependencies
> for my SQL Server Cluster resource. Do I have to restart the cluster
> service for this to take affect? Is there another way for the cluster
> resource to re initialize it's dependencies without restarting?
>

adding disk

I have to add SAN space to an existing cluster. what are the steps?
thanks
Create LUN on SAN
Present LUN to Host computers via SAN Masking software
On one host:
Rescan disks in Disk Administrator on host. (may require host reboot)
Partition disk (may require offsetting the start of the partition to align
LUN boundaries)
Create disk resource on temporary cluster group.
Rescan disks on remaining host nodes (again, ay require reboot of specific
nodes.
Test disk access on all nodes, shifting disk resource as necessary.
On the host for the SQL Instance you wish to add the disk to:
Using Cluster Administrator, Stop the SQL Service, leave the remaining
resources online
Make the SQL service dependent on the new disk resource (see existing disk
resource dependencies)
Start SQL Service using Cluster Administrator
Add folders and data.
Geoff N. Hiten
Senior Database Administrator
Microsoft SQL Server MVP
"vision" <vision@.discussions.microsoft.com> wrote in message
news:192B4B9C-D1BB-4A46-9322-771B4C2F3987@.microsoft.com...
>I have to add SAN space to an existing cluster. what are the steps?
> thanks
|||thanks'
I am not sure what a temporary disk resource is.
"Geoff N. Hiten" wrote:

> Create LUN on SAN
> Present LUN to Host computers via SAN Masking software
> On one host:
> Rescan disks in Disk Administrator on host. (may require host reboot)
> Partition disk (may require offsetting the start of the partition to align
> LUN boundaries)
> Create disk resource on temporary cluster group.
> Rescan disks on remaining host nodes (again, ay require reboot of specific
> nodes.
> Test disk access on all nodes, shifting disk resource as necessary.
> On the host for the SQL Instance you wish to add the disk to:
> Using Cluster Administrator, Stop the SQL Service, leave the remaining
> resources online
> Make the SQL service dependent on the new disk resource (see existing disk
> resource dependencies)
> Start SQL Service using Cluster Administrator
> Add folders and data.
> --
> Geoff N. Hiten
> Senior Database Administrator
> Microsoft SQL Server MVP
>
>
> "vision" <vision@.discussions.microsoft.com> wrote in message
> news:192B4B9C-D1BB-4A46-9322-771B4C2F3987@.microsoft.com...
>
>
|||Temporary resource group, not temporary disk resource.
This is just a group you made up to hold the resource while you are testing
it. Once you have confirmed it moves between hosts as you expect, you moe
the disk resource into the SQL group before setting the dependencies.
Geoff N. Hiten
Senior Database Administrator
Microsoft SQL Server MVP
"vision" <vision@.discussions.microsoft.com> wrote in message
news:9CDCB135-2CBF-417E-B158-FC3BA891D421@.microsoft.com...[vbcol=seagreen]
> thanks'
> I am not sure what a temporary disk resource is.
> "Geoff N. Hiten" wrote:
|||If you need to replace the disk, or want to swap it out, use the Cluster
Recovery Utility to change the resource dependencies. Then you copy the
contents of the old volume to the new and swap the drive letters.
The SQL Server resources will have to be offline during this process, but
you won't have to hack the registry to refer to a new drive letter.
The download contains a reference document.
http://www.microsoft.com/downloads/details.aspx?familyid=2BE7EBF0-A408-4232-9353-64AAFD65306D&displaylang=en
Sincerely,
Anthony Thomas

"Geoff N. Hiten" <SQLCraftsman@.gmail.com> wrote in message
news:eNEP0ieAHHA.4472@.TK2MSFTNGP03.phx.gbl...
> Temporary resource group, not temporary disk resource.
> This is just a group you made up to hold the resource while you are
testing
> it. Once you have confirmed it moves between hosts as you expect, you moe
> the disk resource into the SQL group before setting the dependencies.
> --
> Geoff N. Hiten
> Senior Database Administrator
> Microsoft SQL Server MVP
>
> "vision" <vision@.discussions.microsoft.com> wrote in message
> news:9CDCB135-2CBF-417E-B158-FC3BA891D421@.microsoft.com...
>

Adding and additional drive

On a database server, I have mapped a new drive letter to
a SAN so that I can backup my database. When I go into
Enterprise Manager, I can see the drive, but when I try to
create a new backup device, it gives me an error stating
that 'the directory in whch you want to create this file
does not exist'.
If I try to create a new data or log file for a database
on that server, I do not see the drive.
Should I just reboot the server or is it something else?
SQL Server will probably not see mapped drives... it is running under a
different account than what you used when you mapped the drive.
The BEST way to do this is to make sure that the account SQL Server is
running under has rights to the remote share.
Simply issue a backup using the UNC
BACKUP DATABASE master TO DISK = '\\RemoteServer\SomeShare\master.bak' WITH
INIT
Keith
"canaries" <anonymous@.discussions.microsoft.com> wrote in message
news:225801c49a93$8ec19da0$a501280a@.phx.gbl...
> On a database server, I have mapped a new drive letter to
> a SAN so that I can backup my database. When I go into
> Enterprise Manager, I can see the drive, but when I try to
> create a new backup device, it gives me an error stating
> that 'the directory in whch you want to create this file
> does not exist'.
> If I try to create a new data or log file for a database
> on that server, I do not see the drive.
> Should I just reboot the server or is it something else?
>
|||http://support.microsoft.com/default...b;en-us;555128
Everything you ever wanted to know about backing up to remote shares.
Geoff N. Hiten
Microsoft SQL Server MVP
Senior Database Administrator
Careerbuilder.com
I support the Professional Association for SQL Server
www.sqlpass.org
"canaries" <anonymous@.discussions.microsoft.com> wrote in message
news:225801c49a93$8ec19da0$a501280a@.phx.gbl...
> On a database server, I have mapped a new drive letter to
> a SAN so that I can backup my database. When I go into
> Enterprise Manager, I can see the drive, but when I try to
> create a new backup device, it gives me an error stating
> that 'the directory in whch you want to create this file
> does not exist'.
> If I try to create a new data or log file for a database
> on that server, I do not see the drive.
> Should I just reboot the server or is it something else?
>

Adding and additional drive

On a database server, I have mapped a new drive letter to
a SAN so that I can backup my database. When I go into
Enterprise Manager, I can see the drive, but when I try to
create a new backup device, it gives me an error stating
that 'the directory in whch you want to create this file
does not exist'.
If I try to create a new data or log file for a database
on that server, I do not see the drive.
Should I just reboot the server or is it something else?SQL Server will probably not see mapped drives... it is running under a
different account than what you used when you mapped the drive.
The BEST way to do this is to make sure that the account SQL Server is
running under has rights to the remote share.
Simply issue a backup using the UNC
BACKUP DATABASE master TO DISK = '\\RemoteServer\SomeShare\master.bak' WITH
INIT
--
Keith
"canaries" <anonymous@.discussions.microsoft.com> wrote in message
news:225801c49a93$8ec19da0$a501280a@.phx.gbl...
> On a database server, I have mapped a new drive letter to
> a SAN so that I can backup my database. When I go into
> Enterprise Manager, I can see the drive, but when I try to
> create a new backup device, it gives me an error stating
> that 'the directory in whch you want to create this file
> does not exist'.
> If I try to create a new data or log file for a database
> on that server, I do not see the drive.
> Should I just reboot the server or is it something else?
>|||http://support.microsoft.com/default.aspx?scid=kb;en-us;555128
Everything you ever wanted to know about backing up to remote shares.
--
Geoff N. Hiten
Microsoft SQL Server MVP
Senior Database Administrator
Careerbuilder.com
I support the Professional Association for SQL Server
www.sqlpass.org
"canaries" <anonymous@.discussions.microsoft.com> wrote in message
news:225801c49a93$8ec19da0$a501280a@.phx.gbl...
> On a database server, I have mapped a new drive letter to
> a SAN so that I can backup my database. When I go into
> Enterprise Manager, I can see the drive, but when I try to
> create a new backup device, it gives me an error stating
> that 'the directory in whch you want to create this file
> does not exist'.
> If I try to create a new data or log file for a database
> on that server, I do not see the drive.
> Should I just reboot the server or is it something else?
>