Cleaing up Those Huge MSSQL Log Files

By admin, August 17, 2015 12:21 pm

Today, one of my clients has complained his server is running out of space abnormally, using WinDirStat, I was able to identify the cause of the problem.

It was the MSSQL log files occupied over 20GB of space. The clean up process is pretty straight forward, manually run “EXEC sp_cycle_errorlog” 6 times or more depending how many log copies you kept, the command erased all those gigantic log files and freed up the space as you wished for, simple as that.

There is always something new for me to learn everyday, which is a good thing! :)

Note: Struggled a bit trouble when login back to Mirosoft SQL Server Management Studio, as the correct format for Server Name is /your_server_name/SQLEXPRESS.

Leave a Reply