June 10, 2013 at 10:03 am
I have some files(SQLAGENT.1, SQLAGENT.2, SQLDump.mdmp, SQLDump.log and SQLAGENT.OUT) in one of the drive under the LOG folder and taking a lot of the space.
Is it okay to delete some of these older files? Can someone please explain what these files does?
SueTons.
Regards,
SQLisAwe5oMe.
June 10, 2013 at 10:23 am
The SQLAgent files are the errorlogs for SQLAgent. Do not delete the .OUT file as that is the current one. there should be no more than 6 cycles of these and they should be small. If they are large view the files, it may be highlighting some issue, resolve that issue and these files will resolve themselves size wise.
mdump files are dump files written out by stack traces, if they are old you can delete them. If you have a large no are they are repeatedly being produced investigate why. You may be hitting a bug that needs reporting to microsoft, they will need the dump files to assist in the resolution,
See the main errorlog to see if you are getting stack traces.
---------------------------------------------------------------------
June 10, 2013 at 11:04 am
george sibbald (6/10/2013)
The SQLAgent files are the errorlogs for SQLAgent. Do not delete the .OUT file as that is the current one. there should be no more than 6 cycles of these and they should be small. If they are large view the files, it may be highlighting some issue, resolve that issue and these files will resolve themselves size wise.mdump files are dump files written out by stack traces, if they are old you can delete them. If you have a large no are they are repeatedly being produced investigate why. You may be hitting a bug that needs reporting to microsoft, they will need the dump files to assist in the resolution,
See the main errorlog to see if you are getting stack traces.
Thanks George, appreciate it.
SueTons.
Regards,
SQLisAwe5oMe.
Viewing 3 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply