Erin Stellato relates a painful experience of tempdb filling up a VM’s drive:
I made a mistake with a script today. I created three new tempdb files sized at 10GB each that filled up a hard drive.
Whoops.
Luckily it was in one of my own testing VMs, so it wasn’t awful. Fixing it, however, was a fun one.
**NOTE: All work was done in a test environment. Proceed with caution if you’re running these commands in Production and make sure you understand the ramifications.
It’s a good opportunity to learn from Erin’s experience.