Tag Archives: MSSQL

“Extend Volume” greyed out in “Disk Management”

Let’s say you are trying to extend a volume and you have the “Extend volumeā€¦” option greyed out in Disk Management (MMC).
Extend_Volume_greyed_out_01

 

Can you still extend the volume?
Short answer: Yes.

 

Is not really necessary to be in the exact same setup as I was to be able to apply the fix, but I am mentioning the full context to make sure you understand the reason why I introduced couple of additional steps.
My setup: Microsoft Windows Server 2008 Enterprise + MSSQL cluster (5 instances) + SAN disks.

 

1. Extend the LUN.
2. Refresh the Disk Management MMC console and check if the additional disk space is available.
Extend_Volume_greyed_out_02
Extend_Volume_greyed_out_03
Of course to be able to extend a volume is necessary to have the unallocated disk space to the right of the partition\volume you wish to extend on the same drive.

 

3. If the disk is part of a cluster, make sure you Turn On Maintenance Mode (Failover Cluster Management MMC -> Storage). This action will not stop/affect the service who is using that disk (in my case will NOT affect my MSSQL instance – no downtime). Turn On Maintenance Mode simply disables couple of disk checks the cluster service performs. If you don’t turn on maintenance mode, it is possible the cluster service to trigger a failover and this will move the disks (where you want to perform the extend) on the other cluster node.
Extend_Volume_greyed_out_04

 

4. Use DISKPART to extend the Volume.
DISKPART> list disk
Extend_Volume_greyed_out_05

DISKPART> select disk 22
Extend_Volume_greyed_out_06

DISKPART> list partition
DIKSPART> select partition 1
DISKPART> list volume
Extend_Volume_greyed_out_07

 

DISKPART> select volume 17
(I executed this command just to show how the volume selection should be done in case your partition has multiple volumes and the automatic default selected volume is not the one you intend to extend)
Extend_Volume_greyed_out_08

 

DISKPART> extend
Extend_Volume_greyed_out_09
Extend_Volume_greyed_out_10

 

5. If the disk is part of a cluster, make sure you Turn Off Maintenance Mode (Failover Cluster Management MMC -> Storage).