Brainlitter » How to whack massive ERRORLOG (errorlog1, errorlog2) files

How to whack massive ERRORLOG (errorlog1, errorlog2) files

You can do it the hard way

  • Stop/Start SQL Server to release current ERRORLOG files and then delete them from C:Program FilesMicrosoft SQL ServerMSSQL.1MSSQLLOG or wherever they might be

 

Or, you can…

 

Do it the easy way

  • Recycle the Error Logs, by running the following SQL Query command…
DBCC ERRORLOG

Such as…

 

image