Forum Discussion

AZAZAZAZ's avatar
AZAZAZAZ
Copper Contributor
Mar 31, 2022
Solved

SQL server 2019 log file take up a lot of space (dmp file)

It is found that disk D has 100g less space these days. It turns out that the DMP file in the path (\ mssql15. MSSqlServer \ MSSQL \ log \ POLYBASE \ dump \) under the SQL server2019 directory takes ...
  • AZAZAZAZ's avatar
    Mar 31, 2022

    I found a solution. Although I don't understand it very well, it works very well.

    Enter Win + R to run services msc,

    Find the service in the picture in the service and prohibit them.

    In this way, the dump folder will not generate DMP files by itself.

    As shown in the figure, you can disable the two SQL POLYBASE services

     

Resources