azure sql vm storage Not extendable

Question

I can't expand the data or log disk on my Azure SQL. However, the option in the SQL Virtual Machine Storage configuration is grayed out.

I then tried to expand the disk directly (from 8GB to 16GB), and the result was as follows:

The DB disk F: is still 7GB in size. Instead, a new disk, SQLVMStoragepool1, has appeared with an 8GB partition and 8GB unused space.

What is happening on this machine, and how can I simply extend the disk/partition of the DB disk?

Answer 1

Hi @CLOUDTASTIC | Norbert Loibl

Thanks for the Question and using Microsoft Q&A

As per my Understanding, you're dealing with a storage configuration issue on your Azure SQL VM.

When the storage configuration option is grayed out, it usually indicates that the VM was deployed with a storage pool that includes DATA and LOG volumes.

Here's what might be happening:

The SQL Server VM was deployed with a storage pool that includes DATA and LOG volumes. This means that the storage is managed as a pool rather than individual disks1.

When you tried to expand the disk directly, it created a new disk (SQLVMStoragepool1) instead of extending the existing disk. This is because the storage pool configuration doesn't allow direct extension of individual disks1.

To resolve this, you can extend the storage pool through the Azure portal. Here's how:

Sign in to the Azure portal and select your VM.

In the left pane of the Virtual Machine Overview tab, select SQL Server configuration under Settings.

Select Manage SQL virtual machine.

In the left pane, select Storage Configuration under Settings.

Select Configure under Configure drive, and then extend the Data, Log, and temporary db (database) volume.

Select the disk size, enter the number of new disks that need to be added to the existing storage pool, and then select Apply.

This process will add disks to the VM and extend the storage pool without modifying the existing disks. If you've already reached the maximum number of data disks for your VM size, you may need to upgrade your VM size to add more disks

Please go through these Documentations that might help you:

https://learn.microsoft.com/en-us/troubleshoot/azure/virtual-machines/windows/cannot-extend-volume-sql-server

https://learn.microsoft.com/en-us/azure/azure-sql/virtual-machines/windows/storage-configuration?view=azuresql&tabs=windows2016Hope this helps. Do let us know if you any further queries.

---

If this answers your query, do click Accept Answer and Yes for was this answer helpful. And, if you have any further query do let us know.

Answer 2

The first screenshot shows exactly my problem, that I cannot click on this option you described.

"I can't expand the data or log disk on my Azure SQL. However, the option in the SQL Virtual Machine Storage configuration is grayed out".

Message: The storage pool is customized.