How do I clear the SQL Server error log?

How do I clear an SQL error log?

In SQL Server Management Studio, open the MANAGEMENT folder, then right click on SQL SERVER LOGS and say CONFIGURE. Check the LIMIT ERROR LOGS box and set the number to 30 (a month's worth). Now, set up a new job in the SQL Agent that runs sp_cycle_errorlog every night at midnight.

How do I move the SQL Server error log?

STEP II: Change the Sql Server Error Log Path In the right pane right click on the Sql Server Instance Service and in the context menu click on the Properties option. The path after the prefix character -e is the current error logs path. Change the path to the desired location.

What is SQL Server error log?

The error log is a central file where all important actions and error messages related to the SQL Server are recorded. The database administrator should examine the log every day. The following procedure describes how to view the error log with the Microsoft SQL Server Management Studio. Procedure.

Where are SQL Server error logs located?

By default, the error log is located at Program Files\Microsoft SQL Server\MSSQL. n \MSSQL\LOG\ERRORLOG and ERRORLOG.