Error while validating the cluster in wondows server 2008 R2 Using local storage

Question

Hi All, I am getting an error while validating the cluster.  Writing to sector 11 on disk with identifier 589e0435 from node vappsql1.win.local Reading sector 11 on disk with identifier 589e0435 from node vappsql1.win.local Reading sector 11 on disk with identifier 589e0435 from node vappsql2.win.local There are multiple disks with identifier 589e0435 There are multiple disks with identifier 589e0435 I am using the local disk for the storage How can i fix this error ?

Answer 1

A cluster needs shared storage. YOu cannot use local storage for a clustered instance of SQL Server. Create storage on a SAN/iSCSI array and validation will pass. If you do not have shared storage, you cannot cluster an instance of SQL Server.

If the storage is on an array but presented locally, then you have a disk signature problem and need to talk to your storage admins.

---

Allan Hirt Blog: http://www.sqlha.com/blog Coming in 2013: Mission Critical SQL Server 2012 - the followup to Pro SQL Server 2008 Failover Clustering

Answer 2

Thank you allan..

I am trying to configure the SQL always on without storage...when i was trying validate i am getting that error...please suggest me to fix this...

Answer 3

I should have asked what you were deploying. I assumed FCI. FCI + WSFC = shared storage requirement. AG + WSFC = no shared storage requirement unless using an FCI as part of the AG.

If the WSFC is trying to validate storage, it thinks something should be added to the cluster. So if it's checking a disk, it may not be a local disk. If it was, Validation would give you a warning and skip most of the disk tests. I just looked at a test AG system I have with 3 nodes with all local instances and that is exactly what happened. Only the List All Disks test ran with the others getting the warning since it says that no disks were available to test.

Having said that, whatever disks it is detecting all have the same signature which is what I mentioned above - and that is generally a bad thing.

---

Allan Hirt Blog: http://www.sqlha.com/blog Coming in 2013: Mission Critical SQL Server 2012 - the followup to Pro SQL Server 2008 Failover Clustering

Answer 4

Thank you allan

I have created cluster  without validating the cluster on 4 machines and after creating cluster when i am checking the partitions expect the C drive all the other drives are offline.

How can take online these disks.

When i try to make online using My Computer manage,,here the  online option is disable.


Please suggest me to fix this issue.

Answer 5

Never create a cluster without passing validation. If this is production, that means you have a WSFC that is technically not supported by Microsoft.

How are the disks presented to the OS? What type of hardware? As I said, how they're presented matters.

If the WSFC is already created, you can remove the disks from the WSFC in Failover Cluster Manager and re-run validation. The disks will be skipped if you re-run.

If the WSFC is not created, then you need to figure out what is causing the issue. I don't have enough information to date to say waht your issue is but I've given you some things to look at.

---

Allan Hirt Blog: http://www.sqlha.com/blog Coming in 2013: Mission Critical SQL Server 2012 - the followup to Pro SQL Server 2008 Failover Clustering