SQL Server: Shrink Error Log

Each and every time that your SQL server is restated your SQL error log is recreated.

The current or last Errorlog is not deleted or overwritten but saved as ErrorLog1 and so on as described in the table below in your default location of C:\Program Files\Microsoft SQL Server\MSSQL\LOG

I was looking for a way to shrink the error log in SQL Server without stopping the service.

It's not possible to shrink but you can clear the error logs (close file and create a new one) using SP_CYCLE_ERRORLOG
Share on Google Plus

About Vittorio Pavesi

    Blogger Comment
    Facebook Comment

0 commenti: