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 |
Database Technologies > MSSQL >