Changing LUNS

We currently have a sql server 2005 server clustered. One one node the disks
are on luns 1, 2, and 3, and on the other node they are on luns 1, 4, and 5.
My question is can I un-present the disks on the second node and then
re-present them and change the luns to 1,2, and 3 like the first node? I
don't know if changing the LUNS will cause any problem with the cluster or if
everything is just run off the drive letters. Thanks!

Hi Morris,

This is how windows shows his disks, I won't change the disk, and I guess
unpresent the disk won't change your thing.
the Id is the disk signature that must be changed.

you can see this in
hklm\system\currentcontrolset\services\cludisk\par ameters\signatures

Here you can see the ID matching the Disk name and these settings are
different on both nodes.
You can change this on the passive node but you can also meshup your
cluster.

The basic Idea is the signature holds the windows disk with the disk name
and device number. If you change this than your windows disk moved from 1 to
4.

Sample
node 1

ID 1c0e170e = device\hardisk1
ID 2c0e170e = device\hardisk2
ID 3c0e170e = device\hardisk3
ID 4c0e170e = device\hardisk4


node 2

ID 1c0e170e = device\hardisk4
ID 2c0e170e = device\hardisk2
ID 3c0e170e = device\hardisk3
ID 4c0e170e = device\hardisk1

You can change the disk 4 with 1 but the ID 4c0e170e = device\hardisk1 must
be the same disk as on node 1 ID 4c0e170e = device\hardisk4 You must be
sure that this is the presented disk.

I have done this but it is always tricky.


--
Greetings,

Robert Smit
Blog : http://fiberman.spaces.live.com/



"morris" <> schreef in bericht
news:1ED31EC6-AD4F-4295-950B-...
> We currently have a sql server 2005 server clustered. One one node the
> disks
> are on luns 1, 2, and 3, and on the other node they are on luns 1, 4, and
> 5.
> My question is can I un-present the disks on the second node and then
> re-present them and change the luns to 1,2, and 3 like the first node? I
> don't know if changing the LUNS will cause any problem with the cluster or
> if
> everything is just run off the drive letters. Thanks!

Robert is right, but to shorten the story; don't try to change this, and
certainly do not change anything in that registry key.

Rgds,
Edwin.

"morris" <> wrote in message
news:1ED31EC6-AD4F-4295-950B-...
> We currently have a sql server 2005 server clustered. One one node the
disks
> are on luns 1, 2, and 3, and on the other node they are on luns 1, 4, and
5.
> My question is can I un-present the disks on the second node and then
> re-present them and change the luns to 1,2, and 3 like the first node? I
> don't know if changing the LUNS will cause any problem with the cluster or
if
> everything is just run off the drive letters. Thanks!

Ok well here is my problem. I am trying to add a new node to my sql cluster
but when I run through the wizard it is failing. I have read on other
websites that this is because the disks are on different luns on the
different nodes?

"Edwin vMierlo [MVP]" wrote:

> Robert is right, but to shorten the story; don't try to change this, and
> certainly do not change anything in that registry key.
>
> Rgds,
> Edwin.
>
> "morris" <> wrote in message
> news:1ED31EC6-AD4F-4295-950B-...
> > We currently have a sql server 2005 server clustered. One one node the
> disks
> > are on luns 1, 2, and 3, and on the other node they are on luns 1, 4, and
> 5.
> > My question is can I un-present the disks on the second node and then
> > re-present them and change the luns to 1,2, and 3 like the first node? I
> > don't know if changing the LUNS will cause any problem with the cluster or
> if
> > everything is just run off the drive letters. Thanks!
>
>
>

Hi Morris,

Is the disk correctly published to the server, So If you bringdown all your
nodes and the new node sees the disk ?
Or can you see the disk with the Fiberchannel/iscsi tools ?


--
Greetings,

Robert Smit
Blog : http://fiberman.spaces.live.com/

"morris" <> schreef in bericht
news:1BA228DA-2C51-45B2-A8FA-...
> Ok well here is my problem. I am trying to add a new node to my sql
> cluster
> but when I run through the wizard it is failing. I have read on other
> websites that this is because the disks are on different luns on the
> different nodes?
>
> "Edwin vMierlo [MVP]" wrote:
>
>> Robert is right, but to shorten the story; don't try to change this, and
>> certainly do not change anything in that registry key.
>>
>> Rgds,
>> Edwin.
>>
>> "morris" <> wrote in message
>> news:1ED31EC6-AD4F-4295-950B-...
>> > We currently have a sql server 2005 server clustered. One one node the
>> disks
>> > are on luns 1, 2, and 3, and on the other node they are on luns 1, 4,
>> > and
>> 5.
>> > My question is can I un-present the disks on the second node and then
>> > re-present them and change the luns to 1,2, and 3 like the first node?
>> > I
>> > don't know if changing the LUNS will cause any problem with the cluster
>> > or
>> if
>> > everything is just run off the drive letters. Thanks!
>>
>>
>>

click advanced.


"morris" <> wrote in message
news:1BA228DA-2C51-45B2-A8FA-...
> Ok well here is my problem. I am trying to add a new node to my sql
> cluster
> but when I run through the wizard it is failing. I have read on other
> websites that this is because the disks are on different luns on the
> different nodes?
>
> "Edwin vMierlo [MVP]" wrote:
>
>> Robert is right, but to shorten the story; don't try to change this, and
>> certainly do not change anything in that registry key.
>>
>> Rgds,
>> Edwin.
>>
>> "morris" <> wrote in message
>> news:1ED31EC6-AD4F-4295-950B-...
>> > We currently have a sql server 2005 server clustered. One one node the
>> disks
>> > are on luns 1, 2, and 3, and on the other node they are on luns 1, 4,
>> > and
>> 5.
>> > My question is can I un-present the disks on the second node and then
>> > re-present them and change the luns to 1,2, and 3 like the first node?
>> > I
>> > don't know if changing the LUNS will cause any problem with the cluster
>> > or
>> if
>> > everything is just run off the drive letters. Thanks!
>>
>>
>>

I have tried that also and everythign adds fine. The problem I ran into was
once the new node was up I moved the cluster name and ip and quorum to the
new node and it would stay on that node for maybe 30 seconds and then fail
back to another node. Should this be expected being I didn't install sql on
this node yet or does this sound like a problem. I had the sql cluster group
offline during this time and was just trying to move the quorum and name and
ip.

"John Fullbright" wrote:

> click advanced
>
>
> "morris" <> wrote in message
> news:1BA228DA-2C51-45B2-A8FA-...
> > Ok well here is my problem. I am trying to add a new node to my sql
> > cluster
> > but when I run through the wizard it is failing. I have read on other
> > websites that this is because the disks are on different luns on the
> > different nodes?
> >
> > "Edwin vMierlo [MVP]" wrote:
> >
> >> Robert is right, but to shorten the story; don't try to change this, and
> >> certainly do not change anything in that registry key.
> >>
> >> Rgds,
> >> Edwin.
> >>
> >> "morris" <> wrote in message
> >> news:1ED31EC6-AD4F-4295-950B-...
> >> > We currently have a sql server 2005 server clustered. One one node the
> >> disks
> >> > are on luns 1, 2, and 3, and on the other node they are on luns 1, 4,
> >> > and
> >> 5.
> >> > My question is can I un-present the disks on the second node and then
> >> > re-present them and change the luns to 1,2, and 3 like the first node?
> >> > I
> >> > don't know if changing the LUNS will cause any problem with the cluster
> >> > or
> >> if
> >> > everything is just run off the drive letters. Thanks!
> >>
> >>
> >>
>
>
>

Yes the disk is published to the node. When I failed over to this new node
the disk would also stay online for 30-60 seconds before failing back to
another node. Could it be because I don't have sql installed on this node
yet? I didn't take the other nodes offline to see if it would stay online if
there wasn't another node to failover to.

"Robert Smit" wrote:

> Hi Morris,
>
> Is the disk correctly published to the server, So If you bringdown all your
> nodes and the new node sees the disk ?
> Or can you see the disk with the Fiberchannel/iscsi tools ?
>
>
> --
> Greetings,
>
> Robert Smit
> Blog : http://fiberman.spaces.live.com/
>
> "morris" <> schreef in bericht
> news:1BA228DA-2C51-45B2-A8FA-...
> > Ok well here is my problem. I am trying to add a new node to my sql
> > cluster
> > but when I run through the wizard it is failing. I have read on other
> > websites that this is because the disks are on different luns on the
> > different nodes?
> >
> > "Edwin vMierlo [MVP]" wrote:
> >
> >> Robert is right, but to shorten the story; don't try to change this, and
> >> certainly do not change anything in that registry key.
> >>
> >> Rgds,
> >> Edwin.
> >>
> >> "morris" <> wrote in message
> >> news:1ED31EC6-AD4F-4295-950B-...
> >> > We currently have a sql server 2005 server clustered. One one node the
> >> disks
> >> > are on luns 1, 2, and 3, and on the other node they are on luns 1, 4,
> >> > and
> >> 5.
> >> > My question is can I un-present the disks on the second node and then
> >> > re-present them and change the luns to 1,2, and 3 like the first node?
> >> > I
> >> > don't know if changing the LUNS will cause any problem with the cluster
> >> > or
> >> if
> >> > everything is just run off the drive letters. Thanks!
> >>
> >>
> >>
>

it seems that you have 2 problems

1) your "Cluster Group" does not stay online on your second node
2) installation problems with SQL

I would suggest we tackle the first one first

can you please sent us more info on the "Cluster Group" moving back to the
node 1 after 30 seconds,
What errors are logged in the system event log when this happens ?

thanks,
Edwin.


"morris" <> wrote in message
news:3C0C66E1-6127-4BD7-8497-...
> I have tried that also and everythign adds fine. The problem I ran into
was
> once the new node was up I moved the cluster name and ip and quorum to the
> new node and it would stay on that node for maybe 30 seconds and then fail
> back to another node. Should this be expected being I didn't install sql
on
> this node yet or does this sound like a problem. I had the sql cluster
group
> offline during this time and was just trying to move the quorum and name
and
> ip.
>
> "John Fullbright" wrote:
>
> > click advanced
> >
> >
> > "morris" <> wrote in message
> > news:1BA228DA-2C51-45B2-A8FA-...
> > > Ok well here is my problem. I am trying to add a new node to my sql
> > > cluster
> > > but when I run through the wizard it is failing. I have read on other
> > > websites that this is because the disks are on different luns on the
> > > different nodes?
> > >
> > > "Edwin vMierlo [MVP]" wrote:
> > >
> > >> Robert is right, but to shorten the story; don't try to change this,
and
> > >> certainly do not change anything in that registry key.
> > >>
> > >> Rgds,
> > >> Edwin.
> > >>
> > >> "morris" <> wrote in message
> > >> news:1ED31EC6-AD4F-4295-950B-...
> > >> > We currently have a sql server 2005 server clustered. One one node
the
> > >> disks
> > >> > are on luns 1, 2, and 3, and on the other node they are on luns 1,
4,
> > >> > and
> > >> 5.
> > >> > My question is can I un-present the disks on the second node and
then
> > >> > re-present them and change the luns to 1,2, and 3 like the first
node?
> > >> > I
> > >> > don't know if changing the LUNS will cause any problem with the
cluster
> > >> > or
> > >> if
> > >> > everything is just run off the drive letters. Thanks!
> > >>
> > >>
> > >>
> >
> >
> >

I never got to the point of installing sql so that answers #2. As for #1 the
event logs are as follows:
a. Cluster resource 'Disk Q:' in Resource Group 'EX Cluster Quorum' failed.

b. Cluster service was halted to prevent an inconsistency within the server
cluster. The error code was 5027.

c.The Cluster Service service terminated unexpectedly. It has done this 1
time(s). The following corrective action will be taken in 60000
milliseconds: Restart the service.

Once the disk failed back to the other node the cluster service actually
stopped as you can see in c above.

"Edwin vMierlo [MVP]" wrote:

> it seems that you have 2 problems
>
> 1) your "Cluster Group" does not stay online on your second node
> 2) installation problems with SQL
>
> I would suggest we tackle the first one first
>
> can you please sent us more info on the "Cluster Group" moving back to the
> node 1 after 30 seconds,
> What errors are logged in the system event log when this happens ?
>
> thanks,
> Edwin.
>
>
> "morris" <> wrote in message
> news:3C0C66E1-6127-4BD7-8497-...
> > I have tried that also and everythign adds fine. The problem I ran into
> was
> > once the new node was up I moved the cluster name and ip and quorum to the
> > new node and it would stay on that node for maybe 30 seconds and then fail
> > back to another node. Should this be expected being I didn't install sql
> on
> > this node yet or does this sound like a problem. I had the sql cluster
> group
> > offline during this time and was just trying to move the quorum and name
> and
> > ip.
> >
> > "John Fullbright" wrote:
> >
> > > click advanced
> > >
> > >
> > > "morris" <> wrote in message
> > > news:1BA228DA-2C51-45B2-A8FA-...
> > > > Ok well here is my problem. I am trying to add a new node to my sql
> > > > cluster
> > > > but when I run through the wizard it is failing. I have read on other
> > > > websites that this is because the disks are on different luns on the
> > > > different nodes?
> > > >
> > > > "Edwin vMierlo [MVP]" wrote:
> > > >
> > > >> Robert is right, but to shorten the story; don't try to change this,
> and
> > > >> certainly do not change anything in that registry key.
> > > >>
> > > >> Rgds,
> > > >> Edwin.
> > > >>
> > > >> "morris" <> wrote in message
> > > >> news:1ED31EC6-AD4F-4295-950B-...
> > > >> > We currently have a sql server 2005 server clustered. One one node
> the
> > > >> disks
> > > >> > are on luns 1, 2, and 3, and on the other node they are on luns 1,
> 4,
> > > >> > and
> > > >> 5.
> > > >> > My question is can I un-present the disks on the second node and
> then
> > > >> > re-present them and change the luns to 1,2, and 3 like the first
> node?
> > > >> > I
> > > >> > don't know if changing the LUNS will cause any problem with the
> cluster
> > > >> > or
> > > >> if
> > > >> > everything is just run off the drive letters. Thanks!
> > > >>
> > > >>
> > > >>
> > >
> > >
> > >
>
>
>