Wsus server cleanup wizard hangs

*
IT Support Perth


You watching: Wsus server cleanup wizard hangs

*

A prevalent administration task of keeping a WSUS server is cleaning up old tradition updays no much longer required running the Server Cleanup Wizard.
*

If you have a huge amount of updates which need cleaning, the Server Cleanup Wizard frequently freezes making it impossible to clean old updays from the WSUS Database.If this happens, install SQL Management Studio onto the server an attach to the Windows Internal Database used by WSUS.Run the adhering to query to clean up old updays (this deserve to take hrs to run):
msgnvarchar(100) CREATE TABLE#outcomes (Col1 INT) INSERT INTO#results(Col1) EXEC spGetObsoleteUpdatesToCleanup DECLARE WC Cursor FOR SELECT Col1FROM #results
*



See more: What Can You Do If Your Diablo 3 Won T Start ), Diablo Iii Does Not Start

After a few hrs the query must finish. Once finiburned, you will certainly have to run a "wsusutil reset" from an elevated command also prompt."wsusutil reset" will certainly additionally take a few hrs to complete as it demands to shave the right to every update on disk versus the database and delete any type of that no much longer exist in the database.Hope this article has been helpful.
Posted byClint Boessenat1:31 AM
*

*
clint.boessen
Clint BoessenPerth, Western Australia, AustraliaSolution Architect
MCSE: Server InfrastructureMCSE: ProductivityMCSE: Cloud Platcreate and InfrastructureJoin My RSS FeedView my complete profile
►  2020(5) ►  2019(9) ►  2018(19) ▼  2017(30) ▼  April(1) ►  2016(32) ►  2015(43) ►  2014(76) ►  2013(92) ►  2012(73) ►  2011(132) ►  2010(146) ►  2009(179)


See more: How To Fix “ Failed To Load Steamui.Dll 2017, How To Fix “Failed To Load Steamui

*
IT Support Perth