July 25, 2006 at 8:54 pm
The error log is growing huge as I turned on the traceflag for deadlocks.
Can I use sp_cycle_errorlog to start new errorlog without restarting SQL Server or does it restart the SQL server also?
July 26, 2006 at 7:33 am
Yes, you can use this quite safely. It won't restart the server. I suggest you create a scheduled task to execute this command as frequently as you feel necessary - every night if you have to. Just make sure that you are able to keep a long enough history of errorlogs to trace any problems that may have started in the recent past.
July 27, 2006 at 11:11 am
You can also just use the base command buried in the stored procedure: DBCC ERRORLOG
RegardsRudy KomacsarSenior Database Administrator"Ave Caesar! - Morituri te salutamus."
Viewing 3 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply