SQL Server with Mr. Denny

Feb 3 2016   7:00AM GMT

Fixing a storage pool that doesn’t have an read-write server

Denny Cherry Denny Cherry Profile: Denny Cherry

Tags:
Cluster
SQL Server
Storage space

Recently I was working on a clients file server cluster and while doing some troubleshooting with Microsoft Support one of Storagethe clustered disks wouldn’t respond correctly. Now this file server cluster is setup in Azure so it is using SIOS Data Keeper to replicate the data between the nodes of the cluster.

The state that the cluster was in looked something like this.

sios

In this configuration the cluster has two nodes FILESERVER01a and FILESERVER01b. The cluster is named FILESERVER01 and the name that users access files through is FILESERVER01V01.  The top three drives were working exactly as expected, but the last one wasn’t working at all.  Nothing could talk to it, nothing could manage it.

Thanks to Dave Bermingham (Clustering MVP, SIOS Employee and all around good guy) we found a forum thread that talked about this same problem and that the root cause was that the pool was registered as a cluster object within Failover Cluster manager.

Once I went into the failover cluster admin and remove the failed object for that pool I could attach the virtual disk again.  Then I just needed to configure the disks to automatically attach on reboot.  That’s easy enough to fix with a little PowerShell.

get-virtualdisk {DiskName} | set-VirtualDisk -IsManualAttach $False

Then into computer management to bring the disk online (or reboot, but this is easier).  Then resetup the SIOS software to replicate and away the data went.

Thankfully it’s fixed, and I can get back to the problem at hand of figuring out the EFS problem on the cluster.

Denny

 Comment on this Post

 
There was an error processing your information. Please try again later.
Thanks. We'll let you know when a new response is added.
Send me notifications when other members comment.

Forgot Password

No problem! Submit your e-mail address below. We'll send you an e-mail containing your password.

Your password has been sent to:

Share this item with your network: