SSoL: Adding disk space with a repartition

I don’t think most of us need to know Linux, but if you end up managing a system, it’s good to have a little idea of how to get around. This is a short series of posts as I remember the skills I used to have back in university.

While working with some SQL Server 2017 tests, I ran out of disk space. I tend to size my VMs around 40GB, and that works for some things, but I’ll run out of space.

2017-06-15 10_09_14-Ubuntu 64-bit SQL Server .210 - VMware Workstation

I needed to expand the VMWare disk. That doesn’t mean Linux sees the space directly, and I had to figure out how to make the partition bigger. I could have added another disk, but I wanted to work through this process. I learned I needed to have an inactive partition, so I download gparted on a live cd and booted to that.

2017-06-15 11_32_50-Virtual Machine Settings

Next I started working through a few of the tutorials on Linux partitions. This one on AskUbuntu was helpful, as I ended up having to move my swap partition to the end of the disk.

2017-06-15 11_42_23-Ubuntu 64-bit SQL Server .210 - VMware Workstation

GParted isn’t completely intuitive for a Windows guy, but I muddled through it.

Once I had the operations I wanted, I applied them, and partitions moved.

2017-07-09 10_57_51-Ubuntu 64-bit SQL Server .210 - VMware Workstation

I rebooted, and checking the main partition properties, I had space.

2017-07-09 11_04_59-Ubuntu 64-bit SQL Server .210 - VMware Workstation

Now, back to SQL Server on Linux.

About way0utwest

Editor, SQLServerCentral
This entry was posted in Blog and tagged , , . Bookmark the permalink.

4 Responses to SSoL: Adding disk space with a repartition

  1. Benjamin Cuningham says:

    I have to do this about twice a year as my media server VM grows. One of these days I will build a proper NAS and replace the bloated old VM with a lean and mean new machine.

  2. kleegeek says:

    It’s even easier if you use the logical volume manager. Then, you can do this from a command line and do not need a GUI to run gparted. Check out http://www.davidklee.net/2017/07/24/sql-server-on-linux-series-additional-drives/ for more details.

    • way0utwest says:

      Not sure that’s easier. A glance through there wasn’t clear, but the issue I had was I couldn’t alter a partition in use. Had to boot from a mini distro.

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s