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