Wsus not updating windows 8
This is how to properly clean up a WSUS server that is critically out of space, and reduce its database size by almost 90%.The first you may know that your server is in trouble is that it only has a few meg free and some services are failing.
The database in WSUS is an embedded SQL Server database (SQL Server Express).Under "Options" in the WSUS admin tool, you can find the cleanup wizard.This does not necessarily remove disk files you would expect and can need some encouragement by manually "unapproving" updates under "All Updates".Silverlight 5 Build 5.1.30214.0 Released March 11, 2014 Silverlight 5 Build 5.1.20913.0 Released October 8, 2013 Silverlight 5 Build 5.1.20513.0 Released July 9, 2013 Silverlight 5 Build 5.1.20125.0 Released March 12, 2013 Silverlight 5 Build 5.1.10411.0 Released May 8, 2012 Silverlight 5 Build 5.0.61118.0 Released December 9, 2011 Silverlight 5 RC Build 4.1.10329.0 Released May 8, 2012 Build 4.1.10111.0 Released February 14, 2012 Build 4.0.60831.0 Released October 11, 2011 Build 4.0.60531.0 Released June 14, 2011 Build 4.0.60310.0 Released April 19, 2011 Build 4.0.60129.0 Released February 14, 2011 Build 4.0.51204.0 Released December 15, 2010 Build 4.0.50917.0 Released September 28, 2010 Build 4.0.50826.0 Released September 1, 2010 Build 4.0.50524.00 Released June 3, 2010 Build 4.0.50401.00 Released April 15, 2010 Build 3.0.50611.0 Released August 10, 2010 Build 3.0.50106.00 Released January 19, 2010 Build 3.0.40818.00 Released September 1, 2009 Build 3.0.40723.00 Released July 27, 2009 Build 3.0.40624.00 Released July 9, 2009 Build 1.0.30715.00 Released July 23, 2008 Build 1.0.30401.00 Released April 4, 2008 Build 1.0.30109.00 Released Jan. All updates to Microsoft Silverlight include functional, performance, reliability and security improvements and are backward compatible with web applications built using previous versions of Silverlight. 4, 2007All updates to Microsoft Silverlight include functional, performance, reliability and security improvements and are backward compatible with web applications built using previous versions of Silverlight.Here are some reasonable instructions on how to do this using the commandline tool to detach and reattach a database.
If you don't have this installed, you can run the SQL commands through Management Studio, or use "Detach" / "Reattach" from the "Tasks" context menu.
First we need to free up some space by deleting redundant data. Over time, this can eat a lot of space in the database with surprisingly few workstations. Delete all of these like this: This removed 90% of the data in the database (several million rows) for me and did not affect WSUS operation or administration, apart from to speed up certain administration views which used old event data.
If you are concerned, and have the means, it would be prudent to back this file up first.
The Scenario: One of my Windows Server 2012 R2 Standard servers installed a large number of updates 200 all at once (so unfortunately I’ve no idea which one caused this problem).
The Problem: After the reboot the server was stuck on the start-up splash screen stating “Updating your system 8%”.
The file itself defaults to living here: If you're less cavalier than me, and care about reporting on recent activity, you can substitute a "delete from ...