SQL Clone
SQLServerCentral is supported by Redgate
Log in  ::  Register  ::  Not logged in

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.

Filed under: Blog Tagged: Linux, sql server, syndicated

The Voice of the DBA

Steve Jones is the editor of SQLServerCentral.com and visits a wide variety of data related topics in his daily editorial. Steve has spent years working as a DBA and general purpose Windows administrator, primarily working with SQL Server since it was ported from Sybase in 1990. You can follow Steve on Twitter at twitter.com/way0utwest


Leave a comment on the original post [voiceofthedba.com, opens in a new window]

Loading comments...