Befriending Dragons

Transform Tech with Anti-bullying Cultures


1 Comment

Save the SQL error logs….

 

Many people use sp_cycle_errorlog to rollover to a new SQL error log periodically. Please make sure this is necessary and/or that you are not doing it too frequently. The more often you roll over the log the greater the chance you will not have troubleshooting or historical information available, especially after a series of unexpected sequential restarts. If you are cycling the log, you probably want to keep more than the default number of 7 logs so you’re less likely to lose valuable troubleshooting information.

 

2199578 How to manage the SQL Server errorlog

http://support.microsoft.com/default.aspx?scid=kb;en-US;2199578

Configure SQL Server Error Logs (General Page)

http://msdn.microsoft.com/en-us/library/ms177285.aspx

“In Object Explorer, expand your server, expand Management, right-click SQLServerLogs, and then click Configure.“