WSUS replica server fails to sync with upstream server

Posted on 2013-01-24
Medium Priority
1 Endorsement
Last Modified: 2014-04-22
Initially our wsus servers version 3.2.7600.226 (2) are synchronizing properly with upstream (3.2.7600.226 also ) that run for a few years, then database size started to grow about 97 GB. Now  2 replica server  (windows 2003 standard) failing to synchronize with the upstream server (windows 2008 standard) it says connection error, an error trying to connect the wsus server. When I perform server cleanup, database error, an error occured trying to perform a database operation. However if you untick this is a replica of the upstream server, it quickly sync and succeeds. I have tried WSUS_Cleanup_CL.exe, WSUS_Driver_Decline.exe and WSUSUTIL nothings helps. Should I  better leave this is a relica of the upstream server untick it syncs and succeeds, what will be the impact, difference if this is untick?
Question by:vanderfield
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
  • 2
LVL 16

Accepted Solution

Bruno PACI earned 1500 total points
ID: 38820053

The difference is that computer inventory database will not be pushed up to the main stream server.

It will be like you have 2 different sites, each onu with its own database of computers and not database consolidation between them.

When you say the database is 97GB are you talking about the computers database that stores the computers inventory or are you talking about the patches datastore that contains downloaded patches ??

If the problem comes from the patches synchronization only then your can change your configuration so that only computers inventory database is synchronized, but patches are download directly from MS WindowsUpdate by both servers.
Of course this will require twice downloads from Internet (one for the upstream server, one for the child server) but until you find a better solution or find a way to clean you patch datastore it may help.

By the way, emptying the computers inventory database completly is not a big loss because computers will resubscribe to their WSUS server and upload their inventory information. So in case of a total loss, the inventory database will be recreated automatically in a few hours or a few days.

So if your inventory database is so huge because it contains a lot of obsolete computers (I can't believe it's the computer inventory that is so huge... I'm pretty sure you're talking about the patch datastore) your may find a way to restart from a blank inventory.

If you want my personal opinion, uninstalling the WSUS server, removing all the files (database and patches) and reinstalling WSUS is a few hours affair (less than a day). I wouldn't spend too much time on diagnose and probably I would decide to reinstall from scratch. It's my opinion because I know WSUS just enough to know that inventory will be recreated easily after one or 2 days. But you problem is that probably the trouble comes from the content of the upstream server. Can you manage this one ?

Author Comment

ID: 38830025

97 GB represent downloaded patches, our branches (replicas servers) cannot redownload because of bandwidth issues, tried the export and import but unsuccesfull, any other advice?

Author Closing Comment

ID: 40016443
I have uninstalled and reinstalled WSUS then scheduled the downloads after hours

Featured Post

Office 365 Training for IT Pros

Learn how to provision tenants, synchronize on-premise Active Directory, implement Single Sign-On, customize Office deployment, and protect your organization with eDiscovery and DLP policies.  Only from Platform Scholar.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

A quick step-by-step overview of installing and configuring Carbonite Server Backup.
Learn about cloud computing and its benefits for small business owners.
This video Micro Tutorial explains how to clone a hard drive using a commercial software product for Windows systems called Casper from Future Systems Solutions (FSS). Cloning makes an exact, complete copy of one hard disk drive (HDD) onto another d…
With the advent of Windows 10, Microsoft is pushing a Get Windows 10 icon into the notification area (system tray) of qualifying computers. There are many reasons for wanting to remove this icon. This two-part Experts Exchange video Micro Tutorial s…
Suggested Courses

765 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question