If you run a Windows Server Update Services (WSUS) server, you know that sometimes it can develop problems. Specifically the WSUS database can need a manual clean up. There are several scripts around that handle this but I found one HERE that helped me quite a bit.

Bases

Make sure you meet the system requirements. Chrome doesn’t work with the following older platforms: Windows XP; Windows Vista; Mac OS X 10.6, 10.7, and 10.8. Aug 21, 2019 Enabling the Remove obsolete updates from the WSUS database option in Configuration Manager version 1906 handles the cleanup of “Unused updates and update revisions” (Obsolete updates). It is recommended to enable these options in the Software Update Point configuration on the top-level site to allow Configuration Manager to clean up the.

Note that this script does not replace the WSUS SERVER CLEAN UP WIZARD. If you are having problems with that (like SERVER NODE RESET messages), click HERE for the fix.

Databases Obsolete But Update Fails At 78% Time

To run this script:

  1. Download it directly from us HERE and unzip the contents
    .
  2. Start a PowerShell as an Admin
    .
  3. If you are running WSUS from a Windows Internal Database on Server 2012 enter the following command:
    .
    sqlcmd -I -S .pipeMICROSOFT##WIDtsqlquery -i C:WsusDBMaintenance.sql
    .
    If you are running WSUS from a from a Windows Internal Database on Server 2008 or SBS 2011, enter the following command:
    .
    sqlcmd.exe -I -S np:.pipeMSSQL$MICROSOFT##SSEEsqlquery -i C:WSUSDBMaintenance.sql
    .updated Jul 18 2018
    (Be sure adjust the path of C:WsusDBMaintenance.sql to reflect where you actually put the script)
    .
  4. Wait.

I have not had this take more than 15 minutes but I have read reports of it taking a VERY long time.

I found THIS post and THIS post helpful when dealing with the WSUS problem.

This was a tough one. We have labs full of Windows 7 computers thatget their updates via a WSUS server. These machines were not gettingtheir updates. Many of them were failing with WSUS error 0x80244010 .(There were some other errors as well, which I foolishly did not writedown.)

Error 0x80244010 means 'the client tried to contact the WSUS serverfor more than 200 round trips'.http://blogs.technet.com/b/sus/archive/2008/09/18/wsus-clients-fail-with-warning-syncserverupdatesinternal-failed-0x80244010.aspx. '200' is a hardcoded value. Re-running 'Check for Updates' on theclient several times (I have had to run it three or four times)can fix the issue well enough that the computer gets updates, but thisis irritating.

The underlying problem appears to be twofold:

  • Every update on WSUS (even if they are unapproved) get theirmetadata sent to clients unless the updates are marked as expired.
  • WSUS does not clean unneeded (obsolete? superseded? unapproved?) updates itself. I had beenrunning it as a 'fire and forget' server: allow it to autoapprovesecurity updates and then leaving it alone. This fills the databasewith a bunch of updates that gets sent out.

WSUS has a Cleanup Wizard which is supposed to expire obsolete andunneeded updates. I tried running this, but it would get stuck andhang forever.

Webman mod 4.85 download hen. There is lots of advice about how to fix this problem: defragging harddrives, running the Cleanup Wizard multiple times, running weirdPowershell scripts that launch the Wizard via the commandline. None ofthem worked for me. What worked was the advice on this page:

Although useful, note that the thread contains some unkind words toone of the thread participants. It also spreads out the advice I endedup using across the discussion.

The thread is full of good insight, and well worth reading. However, Ithought it would be helpful to consolidate what I ended up using tosolve our issue.

Data Bases Obsolete But Update Fails At 78%25

First, the problem: WSUS uses an internal database to store itsupdates. The Server Cleanup wizard calls a stored procedure whichtries to expire all old updates at once, and this times out and makesthe Cleanup Wizard hang. Usually, we want atomic all-or-nothingoperations in databases, so when the expiry times out the databasehelpfully rolls back expired updates, leaving us in the position westarted.

In addition to having too many updates it appears that certainobsolete updates have a large number of revisions, which also slowsthe clearout process down. Once these troublesome updates are expired,the rest of the cleanup can be handled relatively efficiently.

Databases Obsolete But Update Fails At 78% 11

To solve the problem, you log into the database directly and run ascript that expires updates one by one. Troublesome updates take along time to expire, but they don't hit the timeout value, soeventually all updates get cleared.

Second: the steps. This boils down to running the following script,provided by user __Russ__ on the forums, based on code byvexation. (Sorry about the long line. I do not know how to safelyinsert linebreaks into the script and am not going to bother findingout.)

  • Download SQL Management Studio Express . We are running WSUS onServer 2008 R2, so I got version 2005, available here:http://www.microsoft.com/en-us/download/details.aspx?id=8961

  • Install SQL Management Studio Express and then start it asadministrator. Set theserver name to be.pipeMSSQL$MICROSOFT##SSEEsqlquery . Apparently for Server2012 this should be .pipeMICROSOFT##WIDtsqlquery.

  • Navigate to Databases -> SUSDB.

  • Make a 'New Query'.

  • Paste the script above into a query window.Then click 'Execute'.

  • Wait a long time. The script will tell you what it is doing in the'Messages' tab, which is helpful.

  • When the script has finished executing your WSUS installation should be clean.

  • Turbulencefd keygen for mac. Run the Cleanup Wizard regularly (I have decided to run it every twomonths) in a vain attempt to keep the database clean from now on.

Later in the thread there is some Powershell script that is supposedto do the same thing, but it did not work for me.

Databases Obsolete But Update Fails At 78% Center

There a few takehome lessons for me from this:

  • Opaque software is terrible. The only reason people were able tosolve his problem was because WSUS (which I treat as a black box,since we auto-approve updates) actually uses SQL server secretly,and it is possible to connect to the SQL server directly and fixthings. If that SQL interface was not accessible we would all bestuck. I run into this issue again and again and again. Softwarethat you cannot troubleshoot and poke at is software you can't fix.

  • Similarly, uninformative progress bars that hide system problems areterrible. There should always be an option to see what the programis doing under the hood, if only so we can see whether the programis actually making progress. Progress bars lie.

  • Cooperative threads where people contribute and improve collectiveknowledge about problems are super-valuable, even when valuableinformation is smeared across the thread. I am so grateful thatthese sysadmins investigated the problem thoroughly and solved it,and I think Microsoft is as well: recently they published a longarticlehttp://blogs.technet.com/b/configurationmgr/archive/2016/01/26/the-complete-guide-to-microsoft-wsus-and-configuration-manager-sup-maintenance.aspxwhich FINALLY addressed this problem. I doubt they would have doneso if the above thread had not existed.

  • This kind of thread is probably not going to be successful onStack Overflow, because Stack Overflow expects fully-formedsolutions, not partial answers that work towards a solution. OverallI vastly prefer Stack Overflow results to the awful Microsoftforums, but in this case the Microsoft forum worked better.

  • WSUS is kind of terrible. I appreciate the declining individualupdates is a useful service, but I mostly want a stable, on-sitecache of Windows updates that our computers can use without taxingour external internet connection. But as updates get larger and morenumerous, WSUS is showing its age more and more. It is also notfire-and-forget software, which is really irritating. On the otherhand, WSUS is gratis with Windows Server. Having to purchase SystemCenter Configuration Manager to get a Windows Updates cache wouldbe worse.