Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
 
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

 

Comments

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

Loading comments...