Windows Server (SBS) bloats often like a little kid who needs his nose CONSTANTLY wiped. Drives me nuts

Ok – so the SBS server is FULL AGAIN. WHAT NOW!?? I deleted exchange clear off it – so it is not those logs, disabled IIS – so not those logs – WHAT NOW!? SBS Monitoring. OK – so follow this 1 (or two once you get in there) and clear out the temp files in

  1. C:\Program Files (x86)\Microsoft SQL Server\MSSQL.1\MSSQL\Data

I had to pay attention to the note at the bottom to enable the .ps1 file.

Also there is a temp.mdf – that too is MASSIVE. Look at properties of the System Databases -> TempdB and see if the ‘large file’ is the one you think it is (there is a file path) Then Follow these instructions … note that a detail is missing on where sqlservr.exe is located – see here.

Don’t forget that to find large files SUPER fast – use Windirstat.exe – cause it is awesome (awesome like Notepad++ and Beyond Compare – yes… that cool!!!)

Share Button

Leave a Reply

Your email address will not be published. Required fields are marked *

Please answer the question so the system knows your a human and not a web-bot * Time limit is exhausted. Please reload CAPTCHA.