Take the 2-minute tour ×  We are running out of space. What is
the safe way to clear the error log?  What is the safe way to
clear this?  share|improve this question add comment  1 Answer
up vote 6 down vote accepted  You can cycle the error log by
calling sp_cycle_errorlog and then that will close the current
error log and cycle the log extensions. Basically, it'll create
a new error log file that SQL Server will be hitting. Then the
archived error log(s) can be treated accordingly (delete/move
with caution). This will not technically "truncate" the log,
it'll just roll it over and you can handle the old logs as you
so please, like any other file system file.  When you do this,
you should see a new log file with an entry that resembles the
following:  The error log has been reinitialized. See the
previous log for older entries.  BOL reference on
sp_cycle_errorlog  share|improve this answer @JohnDaCosta what?
No. Read the question again and take a closer look at the
picture. –  ivanmp Jan 5 '13 at 9:00 @John