SQL Server - How to remove error logs from sql server logs

Asked By prathap chowdary on 26-Mar-12 01:59 AM

One of my production servers having 40 lakhs error logs located in sql server logs.
How can i remove that error logs.......

Please any one help...........

Thanks in advance.....

Somesh Yadav replied to prathap chowdary on 26-Mar-12 02:14 AM
Use sp_cycle_agent_errorlog for SQLAgent log
Web Star replied to prathap chowdary on 26-Mar-12 02:28 AM
the sysadmin sp is  sp_cycle_errorlog use for clear the error log in sql server
you can see this thread to more details about this

hope this help you