MSSQL Log

 

 


SQLDump

   

File

  • SQLDump<nnnn>.txt
  • SQLDump<nnnn>.log
  • SQLDump<nnnn>.mdmp

Dumps indicate that something is not working as expected in SQL Server and

 forcing SQL to either terminate the process or terminate itself.

If you are lazy and not interested to know the cause, go ahead and delete the files.

sp_cycle_errorlog

A new error log is created each time an instance of SQL Server is started

"sp_cycle_errorlog" cycle the error log files without having to restart the instance of SQL Server

EXEC sp_cycle_errorlog ;
GO

 Typically, SQL Server retains backups of the previous six logs and gives the most recent log backup the extension .1

 

 

 

 

Creative Commons license icon Creative Commons license icon