14,502 questions
Yes, you can delete those files. These files are due to a bug in early releases of SQL 2019. Since you recent dump file is a year old, you are apparently a build which is new enough to have that fix.
Is it safe to delete dump files?
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(182.40000000000003, 33%, 27%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EJ%3C/text%3E%3C/svg%3E)
JE
20
Reputation points
HI
I work for a small company and our server is hosted by an ISP. we do not use SQL server but it is installed, presumably as it needed by some of the programs we use. We noticed that our storage was running out and upon investigation, found that there is 1.69TB being used at the following file path
C:\Program Files\Microsoft SQL Server\MSSQL15.BOSQL19\MSSQL\Log\Polybase\dump
It is literally a text file named SQLDUMPER_ERRORLOG of about 58mb and then a vast list of .dmp files of just under 700mb each. The most recent of these files was created in Febraury 2022 and the oldest was created in November 2021. Would it be safe for us to delete these files as they take up about 25% of our total storage on their own?
SQL Server | Other
{count} votes
-
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(128, 8%, 22%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EA%3C/text%3E%3C/svg%3E)
Anonymous2023-06-05T06:52:35.2366667+00:00 Hi @JE
You can take a look at the answers below. If the answer is helpful to you, please accept it.
Sign in to comment
Accepted answer
-
Erland Sommarskog 121.9K Reputation points MVP Volunteer Moderator2023-06-02T22:03:28.0633333+00:00
1 additional answer
Sort by: Most helpful
-
Olaf Helper 47,516 Reputation points2023-06-02T10:00:33.8+00:00 Would it be safe for us to delete these files
If you don't want to send the dumps to MS Support to analyse them, then you can safely delete them.
BTW, have you installed the latest SP+CU for your SQL Server; may that fix the issue?
-
JE 20 Reputation points
2023-06-02T10:21:23.2733333+00:00 Hi Olaf
Thank you for your response. How can i send them to Microsoft?
Unsure about the updates. We do not use SQL at all. as i said.
The below is what is on the server, no one actively uses it.
-
Olaf Helper 47,516 Reputation points
2023-06-02T10:36:48.2466667+00:00 Run the query
SELECT @@VERSIONand compare the build nummer with https://sqlserverbuilds.blogspot.com/
-
JE 20 Reputation points
2023-06-05T07:03:33.2066667+00:00 Thank you Olaf!
Sign in to comment -