SQL Clone
SQLServerCentral is supported by Redgate
Log in  ::  Register  ::  Not logged in

SQL Server – Error Logs recycle without SQL Server Restart

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



Leave a comment on the original post [www.sqlserver-dba.com, opens in a new window]

Loading comments...