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.
746 questions
Windows Server
Windows Server
A family of Microsoft server operating systems that support enterprise-level management, data storage, applications, and communications.
11,721 questions
{count} votes

3 answers

Sort by: Most helpful
  1. Adam J. Marshall 8,016 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 No comments

  2. Adam J. Marshall 8,016 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,566 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.