WSUS replica server fails to sync with upstream server

Posted on 2013-01-24
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
  • 2
LVL 16

Accepted Solution

PaciB earned 500 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

Optimizing Cloud Backup for Low Bandwidth

With cloud storage prices going down a growing number of SMBs start to use it for backup storage. Unfortunately, business data volume rarely fits the average Internet speed. This article provides an overview of main Internet speed challenges and reveals backup best practices.

Question has a verified solution.

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

Suggested Solutions

Title # Comments Views Activity
How to run the DNS query from the server? 5 75
Shadow copies windows server 2003 2 86
Microsoft Remote Desltop License  USER CALS vs DEVICE CALS 5 61
Server HP DL380 G7 13 45
Remote Apps is a feature in server 2008 which allows users to run applications off Remote Desktop Servers without having to log into them to run the applications.  The user can either have a desktop shortcut installed or go through the web portal to…
Issue: One Windows 2008 R2 64bit server on the network unable to connect to a buffalo Device (Linkstation) with firmware version 1.56. There are a total of four servers on the network this being one of them. Troubleshooting Steps: Connect via h…
Windows 8 came with a dramatically different user interface known as Metro. Notably missing from that interface was a Start button and Start Menu. Microsoft responded to negative user feedback of the Metro interface, bringing back the Start button a…
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…

776 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