Answered by:
WSUS DB Space Issue

Question
-
Hi,
I have Windows Server 2012 R2 on which I configured Windows Update Server.
Below is the configuration
Hyper-V (Virtual Machine)
6 GB RAM
4 Cores
100 GB C Drive/Operating System
350 GB D Drive/WSUS Database
Now from past two weeks WSUS Database file is only 1 GB remaining, I have declined many "UPGRADES" and ran "Cleanup Wizard" but it fills when new Synchronization runs.
Please suggest me how can I get a normal space so WSUS will work fine.
Tuesday, December 3, 2019 5:50 AM
Answers
-
Hi,
Please refer to the following steps:
- Please run the following script in elevated PowerShell first to stop the download currently in progress.
(Get-WsusServer).CancelAllDownloads()
- If there are automatic approval items in WSUS, consider stopping first.
- In the WSUS console> Options> Update and Languages, check the following two points:
- In Update Files, check whether "Download update files to this server only when updates are approved" is checked. If "Download express installation files" is checked, it is recommended to uncheck.
- In Update Languages, keep the languages you really need.
- In the WSUS console> Updates> All Updates, Set Approval to "Any Except Declined", Status to "Any" for query, and add "Supersedence" column in the results view. Decline
the following types of updates:
Blue square in the middle: this update has been superseded by another update and superseded another update as well.
Blue square in the right below corner: this update has been superseded by another update.
- In the WSUS console> Options> Server Cleanup Wizard, Run the wizard again.
If this does not solve too much, please consider the method mentioned in this article, delete the WSUSContent folder and perform a reset: "What to do when your WSUSContent folder grows too large".
Hope the above can help you.
Regards,
YicPlease remember to mark as answers if they help.
If you have feedback for TechNet Subscriber Support, contact tnmff@microsoft.com.- Proposed as answer by Yic LvMicrosoft contingent staff Friday, December 6, 2019 5:56 AM
- Marked as answer by Osama-Mansoor Monday, December 9, 2019 6:08 AM
Tuesday, December 3, 2019 8:01 AM - Please run the following script in elevated PowerShell first to stop the download currently in progress.
All replies
-
Hi,
Please refer to the following steps:
- Please run the following script in elevated PowerShell first to stop the download currently in progress.
(Get-WsusServer).CancelAllDownloads()
- If there are automatic approval items in WSUS, consider stopping first.
- In the WSUS console> Options> Update and Languages, check the following two points:
- In Update Files, check whether "Download update files to this server only when updates are approved" is checked. If "Download express installation files" is checked, it is recommended to uncheck.
- In Update Languages, keep the languages you really need.
- In the WSUS console> Updates> All Updates, Set Approval to "Any Except Declined", Status to "Any" for query, and add "Supersedence" column in the results view. Decline
the following types of updates:
Blue square in the middle: this update has been superseded by another update and superseded another update as well.
Blue square in the right below corner: this update has been superseded by another update.
- In the WSUS console> Options> Server Cleanup Wizard, Run the wizard again.
If this does not solve too much, please consider the method mentioned in this article, delete the WSUSContent folder and perform a reset: "What to do when your WSUSContent folder grows too large".
Hope the above can help you.
Regards,
YicPlease remember to mark as answers if they help.
If you have feedback for TechNet Subscriber Support, contact tnmff@microsoft.com.- Proposed as answer by Yic LvMicrosoft contingent staff Friday, December 6, 2019 5:56 AM
- Marked as answer by Osama-Mansoor Monday, December 9, 2019 6:08 AM
Tuesday, December 3, 2019 8:01 AM - Please run the following script in elevated PowerShell first to stop the download currently in progress.
-
350 GB or 100 GB are not enough for WSUS content folder.
Attach another capable HDD which has at least 1TB free space for WSUS contents.
Then move WSUS contents to it. Unless WSUS never function well
Tuesday, December 3, 2019 8:09 AM -
Thanks YIC LV issue resolved.Tuesday, December 3, 2019 1:19 PM
-
Hi Osama-Mansoor,
Glad to see the problem resolved!
If my answers in the current thread helped you, please mark these answers as answers, which will help forum members to find the solution faster.
If you have your own solution, please share it with us.
Thanks again for your cooperation.
Regards,
YicPlease remember to mark as answers if they help.
If you have feedback for TechNet Subscriber Support, contact tnmff@microsoft.com.Wednesday, December 4, 2019 1:08 AM