Home | Contact Us | FAQ | Search & Site Map | Link to Us
Sign In | Join | Other 45 Sites in Network
Home
Discussion Groups
DB Engine
SQL ServerMSDESQL Server CE
Services
Analysis (Data Mining)Analysis (OLAP)DTSIntegration ServicesNotification ServicesReporting Services
Programming
CLRConnectivitySQLXML
Other Technologies
ClusteringEnglish QueryFull-Text SearchReplicationService Broker
General
Data WarehousingPerformanceSecuritySetupSQL Server ToolsOther SQL Server Topics
DirectoryUser Groups
Related Topics
MS AccessOther DB ProductsMS Server Products.NET DevelopmentVB DevelopmentJava DevelopmentMore Topics ...

SQL Server Forum / Other Technologies / Clustering / June 2009

Tip: Looking for answers? Try searching our database.

Cluster physical disk resource cannot failover....

Thread view: 
Enable EMail Alerts  Start New Thread
Thread rating: 
JayInNC - 30 Jun 2009 19:21 GMT
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....
Geoff N. Hiten - 30 Jun 2009 19:43 GMT
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.

Signature

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

>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
[quoted text clipped - 18 lines]
> I've obviously missed a step but not sure which one, any help is
> appreciated....
JayInNC - 30 Jun 2009 19:55 GMT
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

> You probably need to reboot the second node.  It didn't follow along with
> the changes.
[quoted text clipped - 24 lines]
> > I've obviously missed a step but not sure which one, any help is
> > appreciated....
 
Sign In
Join
My Latest Posts
My Monitored Threads
My Blog
My Photo Gallery
My Profile
My Homepage

Start New Thread
Enable EMail Alerts
Rate this Thread



©2010 Advenet LLC   Privacy Policy - Terms of Use
This website includes both content owned or controlled by Advenet as well as content owned or controlled by third parties.