Want to win a PS4? Go Premium and enter to win our High-Tech Treats giveaway. Enter to Win


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

Concerto's Cloud Advisory Services

Want to avoid the missteps to gaining all the benefits of the cloud? Learn more about the different assessment options from our Cloud Advisory team.

Question has a verified solution.

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

Background Information Recently I have fixed file server permission issues for one of my client. The client has 1800 users and one Windows Server 2008 R2 domain joined file server with 12 TB of data, 250+ shared folders and the folder structure i…
Restoring deleted objects in Active Directory has been a standard feature in Active Directory for many years, yet some admins may not know what is available.
Windows 8 comes with a dramatically different user interface known as Metro. Notably missing from the new interface is a Start button and Start Menu. Many users do not like it, much preferring the interface of earlier versions — Windows 7, Windows X…
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…

610 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