Removing Cluster Disk

• Rechana Rajan

  SSCertifiable

  Points: 7709

  More actions

  September 18, 2017 at 1:28 am

  #340062

  We have a two node cluster and we recently added a 1TB cluster disk and joined it to SQL Server. Storage validation is throwing message 'No Disk is Suitable for Validation' . Now I want to remove the disk from SQL Cluster . My believe is it wont bring the SQL Server down even if I remove the disk (No Database or object exists in this disk). Can anyone please advise on how to achieve this.

  Windows Server 2012
  SQL Server 2014

• rvsc48

  SSCertifiable

  Points: 7651

  More actions

  September 18, 2017 at 7:47 am

  #1959784

  You may be able to follow some of these steps.   Based on your comments, each step may or may not apply depending on if the disk was ever properly presented to the cluster and/or Sql Server as a dependency.
  1) From Failover Cluster Manager from one of the nodes - Roles>Select One>Resources>Select Sql Service at bottom>Properties>Dependencies>Delete the Disk> OK  2) Take the disk offline or Maintenance Mode in Failover Cluster Manager  3) From Failover Cluster manager, select Roles>Select One>Resources>Select Sql Service at bottom> Rt Click Resource>Remove from Sql Server (At this point, the disk should show as Available Storage).  Yes, you are correct when you said Sql Server should not be "brought down" if the disk is removed, however, I would probably perform this activity in a non-business hours timeframe just to be safe.  And, definitely assure no database files exists on the disk prior to removal.

• Rechana Rajan

  SSCertifiable

  Points: 7709

  More actions

  September 18, 2017 at 11:22 am

  #1959846

  RVSC48 - Monday, September 18, 2017 7:47 AM

  You may be able to follow some of these steps.   Based on your comments, each step may or may not apply depending on if the disk was ever properly presented to the cluster and/or Sql Server as a dependency.
  1) From Failover Cluster Manager from one of the nodes - Roles>Select One>Resources>Select Sql Service at bottom>Properties>Dependencies>Delete the Disk> OK  2) Take the disk offline or Maintenance Mode in Failover Cluster Manager  3) From Failover Cluster manager, select Roles>Select One>Resources>Select Sql Service at bottom> Rt Click Resource>Remove from Sql Server (At this point, the disk should show as Available Storage).  Yes, you are correct when you said Sql Server should not be "brought down" if the disk is removed, however, I would probably perform this activity in a non-business hours timeframe just to be safe.  And, definitely assure no database files exists on the disk prior to removal.

  Thanks a lot for the response. Actually as I mentioned I have added a new disk to cluster and then to SQL Server , i tried to do a storage validation on that particular disk and it showing message '

• No disks were found on which to perform cluster validation tests.

'