none
Azure Servers - Data Drive expansion

    Question

  • Hi,

    I have a database server running in Azure where the C:\ is for the system and E:\ is for the data. The max I can get for the data drive is just 1TB. Now it's filling up, how can I expand that drive?

    I can add multiple data drives to the server but the max is always 1TB. Is there a way to link these drives?

    Thanks

    Friday, March 3, 2017 7:17 PM

Answers

All replies

  • You can use the technology called striping to combine the capacity of multiple drives into a single volume, thus increasing its size beyond the size of any of the constituents.

    With striping the data currently on the disk has to be moved into different locations, spread across all the disks.  This can't really be done with an existing disk; however, it is possible to mount both an old single volume disk and a new striped disk set on the same VM and then copy the data across.  Then dismount and delete the old disk.

    Likewise, stripe sets can't be enlarged or reduced, you have the same problem.

    For more information refer the below link:

    https://blogs.msdn.microsoft.com/madan/2016/09/28/resize-azure-resource-manager-arm-vm-os-data-disk-using-azure-portal/

    Disclaimer:

    This response contains a reference to a third-party World Wide Web site. Microsoft is providing this information as a convenience to you. Microsoft does not control these sites and has not tested any software or information found on these sites; therefore, Microsoft cannot make any representations regarding the quality, safety, or suitability of any software or information found there. There are inherent dangers in the use of any software found on the Internet, and Microsoft cautions you to make sure that you completely understand the risk before retrieving any software from the Internet.

    Saturday, March 4, 2017 7:27 AM
    Moderator
  • Assuming that you are running Windows Server 2012 or newer, then the recommended approach is to use Storage Spaces. While the process of setting up Storage Spaces on Azure VMs is, for the most part, the same as the one you would follow in an on-premises scenarios, there are some Azure specific caveats (e.g. make sure to use Simple volumes). For details, refer to http://blog.mikehacker.net/2015/01/20/using-storage-spaces-in-microsoft-azure-for-increased-storage-performance/

    If you want to use Storage Spaces in clustered scenarios, refer to  https://blogs.msdn.microsoft.com/dfurman/2014/04/27/using-storage-spaces-on-an-azure-vm-cluster-for-sql-server-storage/

    hth
    Marcin


    Saturday, March 4, 2017 7:35 AM
  • Thanks! The second link looks like what I need. I won't be able to test it out right away but it definitely sounds promising.

    Thanks everyone for replying!

    Monday, March 20, 2017 1:12 PM