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