locked
WSUS DB Space Issue RRS feed

  • 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:
       

    1. Please run the following script in elevated PowerShell first to stop the download currently in progress.
      (Get-WsusServer).CancelAllDownloads()
         

    2. If there are automatic approval items in WSUS, consider stopping first.
        
    3. 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.
        
    4. 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.
        
    5. 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,
    Yic

    Please remember to mark as answers if they help.
    If you have feedback for TechNet Subscriber Support, contact tnmff@microsoft.com.

    Tuesday, December 3, 2019 8:01 AM

All replies

  • Hi,
       

    Please refer to the following steps:
       

    1. Please run the following script in elevated PowerShell first to stop the download currently in progress.
      (Get-WsusServer).CancelAllDownloads()
         

    2. If there are automatic approval items in WSUS, consider stopping first.
        
    3. 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.
        
    4. 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.
        
    5. 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,
    Yic

    Please remember to mark as answers if they help.
    If you have feedback for TechNet Subscriber Support, contact tnmff@microsoft.com.

    Tuesday, December 3, 2019 8:01 AM
  • 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,
    Yic

    Please 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