[Issue description]
Customer complained of very low space on disk C (only 1GB free out of 100GB total disk space), despite the fact that the sum of all folders and files on this drive was around 30GB.
[Problem handling]
At an initial check with Total Commander, customer's allegations were correct: free disk space was at 1GB but all files and folders were totalling cca. 30GB:
After scheduling a HDD check and rebooted the server, the CHKDSK program started running and it corrected some of the filesystem errors. When the CHKDSK finished, the server rebooted again and after analyzing with Total Commander, we found the problem to be located in directory C:\Program Files\Microsoft SQL Server\MSSQL10_50.SQLEXPRESS\MSSQL\Log
[Root cause]
There are 2 root causes here:
1. Incorrect reporting of the occupied space - that was a filesystem error, corrected with CHKDSK
2. Rapid space occupation by the MSSQL Express database, who generates a lot of error logs in certain circumstances
[Solution]
Implement the solution depicted in the following document:
https://support.huawei.com/enterprise/en/bulletins-product/NEWS2000003991?idAbsPath=03_ROOT|03Second_0304|22658044|21781198|21781768|21781990|6644576
Basically, we need to stop all SMC-related services, then stop MSSQL Server service, delete the ERRORLOG files from that specified directory. After that, a certain script needs to be run, to clear the log database (the script can be obtained from http://3ms.huawei.com/km/blogs/details/6005439 ).
