avatar Bipul Raman Engineer | Speaker

Resolving Space Issues on SharePoint Server caused due to SP Logs
Posted by Bipul Raman on July 05, 2016.

Well, freeing space on server, cleaning up logs are usually admin tasks, but in case of Development servers, Mostly Developers are doing those tasks. Therefore, this particular article i have written from developers prospective.

Case & Solution:  
In case your SharePoint  Server is running out of Storage, Please check with Win Dir tool as shown in the above image. You can download that tool from below link: 
Download URL: https://windirstat.info/download.html

In most of the cases it is due to Logs files created by SharePoint.By inspecting WinDirStat tool, If you find any DATA folder under Program Files >> SQL Server >> … >> is occupying exceptionally high space,List out which DB logs are taking more spaces.
Run the below SQL scripts. Replace the WSS_Content_DB with Actual DB name which occupying higher space. Repeat the process for every single DB which is taking more space.

SQL Script: