dbTalk Databases Forums  

Cluster physical disk resource cannot failover....

microsoft.public.sqlserver.clustering microsoft.public.sqlserver.clustering


Discuss Cluster physical disk resource cannot failover.... in the microsoft.public.sqlserver.clustering forum.



Reply
 
Thread Tools Display Modes
  #1  
Old   
JayInNC
 
Posts: n/a

Default Cluster physical disk resource cannot failover.... - 06-30-2009 , 01:21 PM






I have a 2 node sql 2005 cluster (64 bit ent edition) running on Windows
Server 2003 (64 bit ent edition) utilizing an HP iscsi storage array. I
recently became aware of the disk alignment issues with sans and wanted to
test reconfiguring one of the shared drives.

I picked a drive owned by node 1 and did the following:
1 - Deleted the physical drive resource from the cluster
2 - Ran diskpart on node 1, deleting the existing partition, created a new
partition using align=64
3 - Using Disk Management I formatted the partition using 64k and assigned
it the same drive letter it had formerly
4 - Added it back to the cluster as a disk resource

All good up to this point. Problem is, I cannot fail over this drive to the
other node (and this used to work). Running disk management on the other
node, I can see the drive but it has no drive letter and I cannot assign it
one.

I've obviously missed a step but not sure which one, any help is
appreciated....

Reply With Quote
  #2  
Old   
Geoff N. Hiten
 
Posts: n/a

Default Re: Cluster physical disk resource cannot failover.... - 06-30-2009 , 01:43 PM






You probably need to reboot the second node. It didn't follow along with
the changes.

You can try a rescan of the disks on node 2 first, but I doubt that will
help.

--
Geoff N. Hiten
Principal SQL Infrastructure Consultant
Microsoft SQL Server MVP


"JayInNC" <JayInNC (AT) discussions (DOT) microsoft.com> wrote

Quote:
I have a 2 node sql 2005 cluster (64 bit ent edition) running on Windows
Server 2003 (64 bit ent edition) utilizing an HP iscsi storage array. I
recently became aware of the disk alignment issues with sans and wanted to
test reconfiguring one of the shared drives.

I picked a drive owned by node 1 and did the following:
1 - Deleted the physical drive resource from the cluster
2 - Ran diskpart on node 1, deleting the existing partition, created a new
partition using align=64
3 - Using Disk Management I formatted the partition using 64k and assigned
it the same drive letter it had formerly
4 - Added it back to the cluster as a disk resource

All good up to this point. Problem is, I cannot fail over this drive to
the
other node (and this used to work). Running disk management on the other
node, I can see the drive but it has no drive letter and I cannot assign
it
one.

I've obviously missed a step but not sure which one, any help is
appreciated....


Reply With Quote
  #3  
Old   
JayInNC
 
Posts: n/a

Default Re: Cluster physical disk resource cannot failover.... - 06-30-2009 , 01:55 PM



Thanks Geoff...

Darn, I was hoping I had just missed a step and no reboot would be needed. I
did try a rescan via the iscsi tool but as you suspected it did not help.

Thank you for the quick reply!

J

"Geoff N. Hiten" wrote:

Quote:
You probably need to reboot the second node. It didn't follow along with
the changes.

You can try a rescan of the disks on node 2 first, but I doubt that will
help.

--
Geoff N. Hiten
Principal SQL Infrastructure Consultant
Microsoft SQL Server MVP


"JayInNC" <JayInNC (AT) discussions (DOT) microsoft.com> wrote in message
news:30513CBF-8377-46B6-9076-C116401B7C8F (AT) microsoft (DOT) com...
I have a 2 node sql 2005 cluster (64 bit ent edition) running on Windows
Server 2003 (64 bit ent edition) utilizing an HP iscsi storage array. I
recently became aware of the disk alignment issues with sans and wanted to
test reconfiguring one of the shared drives.

I picked a drive owned by node 1 and did the following:
1 - Deleted the physical drive resource from the cluster
2 - Ran diskpart on node 1, deleting the existing partition, created a new
partition using align=64
3 - Using Disk Management I formatted the partition using 64k and assigned
it the same drive letter it had formerly
4 - Added it back to the cluster as a disk resource

All good up to this point. Problem is, I cannot fail over this drive to
the
other node (and this used to work). Running disk management on the other
node, I can see the drive but it has no drive letter and I cannot assign
it
one.

I've obviously missed a step but not sure which one, any help is
appreciated....




Reply With Quote
Reply




Thread Tools
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

vB code is On
Smilies are On
[IMG] code is On
HTML code is Off



Powered by vBulletin Version 3.5.3
Copyright ©2000 - 2012, Jelsoft Enterprises Ltd.