If some long running error situation , the Error Log can become very big. In those situations , it can be time-consuming to search for specific Messages. 

It is a good idea to recycle the SQL Server Error Logs . To create a new Error Log file without restarting SQL Server , use the sp_cycle_errorlog  system stored procedure.

This closes down the current error log and cycles the error log 

--execute  the sp_cycle_errorlog
EXEC sp_cycle_errorlog

See Also

SQL Server - Grant execute on all stored procedures