Refer to the SQL Server2019 occupy large hard disk space is what reason? Can solve?

Problem description

Partition of 811 gb of disk space, D right attribute view footprint 720 gb, enter the D disk selection all documents (including view hidden files), in the delete spam, disk cleanup after operation, all files take up the space is 229 gb!!!!! Dish (formerly also strange, D is not what special things, accidentally discovered how hard actually there are only few space!!! )
In the Settings - to store the check found in drive storage space usage, D dish there is such a classification occupies most of my disk space:
Caption


Later found that the problem may be out in the software SQL server2019 called * * _ _ * * [Microsoft SQL Server] folder, as shown in figure:
Caption


Right to view this file attributes, take up the space is 2.78 GB,


But I found that when I was in hard copy to the activities of the file transfer has the size of the detected 493 gb!!!!!!


What a great god can tell me this nearly five hundred more than four hundred GB is the gap between what happened? How it is produced: sobs, the problem how to solve ah ~ ~ because just started learning database, only two experiment set up the database, what reason be?

CodePudding user response:

That you enter this folder and see what file

CodePudding user response:

Haven't noticed that there are these two files, [MSAS15. MSSQLSERVER] - [config, data, log, temp, bin, backup] these,
[MSSQL15 MSSQLSERVER \ MSSQL] - [data backup, binn, ftdata, install, jobs, the log, repldata] these,
Is in the process of using database operations, etc. Some of the log file cache? Don't know what can I delete the these temporary take up so much space?

CodePudding user response:

refer to the second floor RangerKnight response:

Haven't noticed that there are these two files, [MSAS15. MSSQLSERVER] - [config, data, log, temp, bin, backup] these,
[MSSQL15 MSSQLSERVER \ MSSQL] - [data backup, binn, ftdata, install, jobs, the log, repldata] these,
Is in the process of using database operations, etc. Some of the log file cache? Don't know what can I delete the these temporary take up so much space?

Concrete will also have to see which subfolders, and ultimately what are caused by the size of the file,

CodePudding user response:

reference RINK_1 reply: 3/f

Quote: refer to the second floor RangerKnight response:

Haven't noticed that there are these two files, [MSAS15. MSSQLSERVER] - [config, data, log, temp, bin, backup] these,
[MSSQL15 MSSQLSERVER \ MSSQL] - [data backup, binn, ftdata, install, jobs, the log, repldata] these,
Is in the process of using database operations, etc. Some of the log file cache? Don't know what can I delete the these temporary take up so much space?

Concrete will also have to see which subfolders, and is ultimately what files, the size of the

OK! Which file I'll give it a try, I put the two original experiment database to deleted, also not line, don't know that part left, can only try the

CodePudding user response:

To view a file download WizTree, take up the condition be clear at a glance