How to recycle the error log file on Microsoft SQL server

Simply run the following query to generate a new error log file. This means you can then move the previous error log file off the server to analyse it and also to save disk space.

sp_cycle_errorlog

Leave a Reply

Your email address will not be published. Required fields are marked *