SQL Server Error Logs recycle without SQL Server Restart
Posted by: SQL Server DBA,
on 26 Jan 2012 |
View original | Bookmarked: 0 time(s)
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 AlsoSQL Server - Grant execute on all stored procedure...