SQL server logs – so many no: of logs | SQL Server Performance Forums

SQL Server Performance Forum – Threads Archive

SQL server logs – so many no: of logs

Hi This is regarding SQL server log files that comes under management > SQL server logs . I can see one Current file (used by server now) and 41 archived logs .How can i reduce to 5 or 6 ? Is there any setting that does it automatically?? pls advice rajiv
SQLserver version is 7.00
Yes you can control the no of error log files after each time they are recycled. Here are the steps to do it from enterprise manager
1. Right click on SQL Server logs and goto configure
2. Here you can set the maximum no of error log files
Thanks Raj, that was really helpful rajiv
And you can use sp_cycle_errorlog to recycle the log without restarting the SQL services. Satya SKJ
This posting is provided “AS IS” with no rights for the sake of knowledge sharing.