SQL Server Error Logs

To get the path for error log location

SELECT SERVERPROPERTY(‘ErrorLogFileName’);

It will return something like the following:

D:\Program Files\Microsoft SQL Server\MSSQL.1\MSSQL\LOG\ERRORLOG

When SQL Server is re-started it will create new Error Log file.

Creating new error log file without re-starting the sql server

This will create new error log file

exec sp_cycle_errorlog

GO

This will create new sql server agent log file

exec sp_cycle_agent_errorlog

go