Loading Synchronization history from the past one month and still it;s 70%

Smijo Baby 1 Reputation point
2021-12-01T09:34:42.05+00:00

Hi,

In Windows Server 2019, we're running WSUS 10.0.17763.1. We had to remove and re-add the role due to a WSUS problem. After that, it's Loading Synchronization History for the previous month, which is still at 70%. I'm not sure how I'm going to do it quickly.

Microsoft System Center
Microsoft System Center
A suite of Microsoft systems management products that offer solutions for managing datacenter resources, private clouds, and client devices.
826 questions
Windows Server
Windows Server
A family of Microsoft server operating systems that support enterprise-level management, data storage, applications, and communications.
12,127 questions

3 answers

Sort by: Most helpful
Most helpful Newest Oldest
  1. Adam J. Marshall 8,626 Reputation points MVP
    2021-12-03T05:07:19.243+00:00

    This will keep happening if you don't perform all of the proper WSUS maintenance. Quick fix for you 

    truncate table tbEventInstance

    This will remove all sync history so you can load it.

    Again, if you re-installed properly (deleting the database and any trace of WSUS as depicted in my guide), you wouldn't have this issue because there would not be any sync history to load other than a few syncs.

    1 person found this answer helpful.
    0 comments
  2. Adam J. Marshall 8,626 Reputation points MVP
    2021-12-01T14:50:34.343+00:00

    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/

    To quote myself:

    Just because you’ve installed a new WSUS server, doesn’t mean that it’s clean or optimized; it just means that it’s NEW!

    Also, if you just reinstalled WSUS, and you're experiencing prior sync history, then it sounds like you didn't reinstall it correctly.

    https://www.ajtek.ca/wsus/how-to-remove-wsus-completely-and-reinstall-it/

  3. Rita Hu -MSFT 9,626 Reputation points
    2021-12-02T07:08:28.933+00:00

    Thanks for your response.

    Please try to run the wsusutil.exe command first and then confirm whether the issue will be resolved or not.
    Open cmd as an administrator and navigate to wsusutil.exe tool. Then run the wsusutil.exe postinstall command:
    154324-3.png

    If the answer is the right solution, please click "Accept Answer" and kindly upvote it. If you have extra questions about this answer, please click "Comment".
    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.