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

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

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.....

Regards,
Prathap.
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
http://www.databasejournal.com/features/mssql/article.php/3587611/Cycling-the-ERRORLOG-file-and-Deleting-Backup-History-Information.htm 
http://www.sqlusa.com/bestpractices2005/administration/cycleerrorlog/ 

hope this help you