C drive has filled up, Delete dump files from mssql server

When there is something “unexpected”, SQL Server kills the SPID and generates a dump. Due to this, C drive has filled up and database is about to crash or has stopped processing.

Checklist to free space

1. cycle the SQL errorlog to remove large error log files from the C drive - see script below

2. clear out old mdf and ldf files from the \Data directory

3. clear out old stack dumps and crash dumps from \LOG directory

4. remove any redundant backup files

5. delete old roaming user profiles from C:\documents and settings

6. check any \temp directories and .tmp files for files to delete

7. empty the Recycle Bin

Here is an image with location

Delete the Log Files.