Home Forums SQL Server 2016 SQL Server 2016 - Administration Running out of space on Server OS drive, where SQL Server app located, what to clear out? RE: Running out of space on Server OS drive, where SQL Server app located, what to clear out?

  • quinn.jay - Thursday, January 11, 2018 3:58 PM

    I'm running a MS Windows Server 2012 R2, and SQL Server 2016 SP2, the main HDD OS drive is split into two partitions, C:\ and D:\, with lots of space on D:\ and only 60GB total space on C:\ now with less than 5GB left, it's in the red.

    Besides using Minitool trade space around, a radical move, what all can I delete log file wise that keeps growing? I'm already shrinking the T log files each week, and I have found and deleted all the /tmp, /temp, cache, etc usual places.

    How can I delete those old archive logs I see in the log viewer? I have found info on deleting it so I think, but its not it, I want to delete a large swatch of them. I see stuff like go to the database, right click, props, file, slect the log and then remove. Thats not removing those old archive logs I have fro mte h day this thign was stood up.

    Any and all help is greatly appreciated.

    Thanks

    If there are user databases on the c drive move them to d drive.

    60Gb is` a little on the small side for a windows 2012 R2 server system drive, check the page file setting and modify that too.
    The c drive only needs a page file of about 400MB to 800MB for memory dump during BSOD

    -----------------------------------------------------------------------------------------------------------

    "Ya can't make an omelette without breaking just a few eggs" 😉