How to cleanup and move SUSDB installed on WID

Boopathi Subramaniam 3,196 Reputation points
2021-08-31T17:49:40.95+00:00

Hi,

SUSDB in WID is occupy more space of the Drive.
128031-wsus.jpg

  1. How to reduce the size of SUSDB in WID on the same Drive
  2. How to move the SUSDB in WID to different Drive
Windows Server
Windows Server
A family of Microsoft server operating systems that support enterprise-level management, data storage, applications, and communications.
12,169 questions
Microsoft Configuration Manager Updates
Microsoft Configuration Manager Updates
Microsoft Configuration Manager: An integrated solution for for managing large groups of personal computers and servers.Updates: Broadly released fixes addressing specific issue(s) or related bug(s). Updates may also include new or modified features (i.e. changing default behavior).
965 questions
0 comments
Accepted answer
  1. Adam J. Marshall 8,706 Reputation points MVP
    2021-09-01T19:04:48.683+00:00

    The better method for shrinking the SUSDB on the WID is to connect to the WID using SSMS and shrink it manually from there.

    https://www.ajtek.ca/wsus/how-do-i-connect-to-the-windows-internal-database-wid/

    Are you performing the proper WSUS maintenance including but not limited to running the Server Cleanup Wizard (SCW), declining superseded updates, running the SQL Indexing script, etc.?

    https://www.ajtek.ca/wsus/how-to-setup-manage-and-maintain-wsus-part-8-wsus-server-maintenance/

    @Pavel yannara Mirochnitchenko mentioned reconfiguring the SUP/WSUS instance (https://www.ajtek.ca/wsus/how-to-remove-wsus-completely-and-reinstall-it/) and you can do that, but it takes time and energy to continue to do that on a consistent basis if you continue to have problems. Performing the proper maintenance will prevent you having to reinstall (I'm using the same WSUS instance and database from 2014 to present day).

    0 comments

2 additional answers

Sort by: Most helpful
Most helpful Newest Oldest
  1. Pavel yannara Mirochnitchenko 11,716 Reputation points
    2021-09-01T10:05:11.247+00:00

    I would recommend to totally reconfigure SUP from scratch. It is quite easy task to build up from scratch and you get rid of all old s..t. :)

    1 person found this answer helpful.
  2. Rita Hu -MSFT 9,626 Reputation points
    2021-09-01T06:59:33.207+00:00

    Hello @Boopathi Subramaniam ,

    Thanks for your posting on Q&A.

    It is recommended to clean up the WSUS database. We could follow this link to reindex the database and decline the superseded updates by PowerShell if you haven't tried before.

    How to move the SUSDB in WID to different Drive
    It is not recommended to do this.

    Regards,
    Rita

    If the response is helpful, please click "Accept Answer" and upvote it.
    Note: Please follow the steps in our documentation to enable e-mail notifications if you want to receive the related email notification for this thread.