40GB Log File!

I was investigating the cause of lack of space on my SQL Server some more today, and did a dir /s >> dump.txt to get it out into a text file. After some Excel Kung-Fu I got a breakout of all the folders and their respective file sizes.

The one that caught my eye, was that my SQL Server folder was over 300 gigabytes. Wow. That's bloody huge. I tried shrinking it, backing it up (thinking it'd truncate the log), rebooting the entire server (thinking something was stuck) ... But no. Eventually, I found the cause.

HDD Space

Previously, I had meticulously crafted a slew of batch file scripts, SQL Server statements, stored procedures and scheduled tasks to get this terrible project to work. And it worked. 33 databases later, it's still working, and bloody huge.