ms sql error logs consuming too much space
i needed to delete some MS sql server logs the other day because the drive they were on was running low on free space. the in use log is named “ERRORLOG” and can’t be deleted until the logs are cycled. you can force this process to happen by running the stored procedure sp_cycle_errorlog.
new query example:
EXEC sp_cycle_errorlog ;
GO
sources:
http://msdn.microsoft.com/en-us/library/ms182512.aspx
http://www.dbadiaries.com/sql-server-error-log-consuming-lots-of-disk-space
http://fkauffmann.blogspot.com/2012/06/how-to-safely-delete-sql-server.html