I'm looking after a server which is generating daily errorlog files which are over 300MB in size. We keep the last 99 logs and cycle the error log daily. To reduce the space on the drive these logs are taking does anyone see any issues with using the COMPACT command to compress these files?
I was planning on running the command COMPACT /C /I F:\MSSQL11.MSSQLSERVER\MSSQL\Log\ERRORLOG.* from a SQL Server Agent job right after running the sp_cycle_errorlog command.