asked on

How can I delete my declined updates from my WSUS 3.0 Sp1 database?

I had Auto approve all updates for my test group because i thought that WSUS would only download updates when it detected that a computer required the update but realized that i was very wrong when my 20gb partition i setup for WSUS updates was full and starting causing the updates to fail. I reconfigured my auto approvals and declined the 20000 un-needed updates, extended the partition to 30gb and ran the server cleanup wizard which only deleted 4gb of data tried to us the wsusutil but it doesn't have the switch to delete updates any more and i downloaded the wsus debug tool and ran the purge unneeded files tool which deleted about another 2 gbs of stuff. Currently my database is almost 25gb, I can see that only about 2000 updates are any thing other then declined and that all of my declined updates 18000+ are still in my database. What do i need to do to get all of the declined updates out of my database?

ASKER CERTIFIED SOLUTION

AutoIt_Airwolf

membership

This solution is only available to members.

To access this solution, you must be a member of Experts Exchange.

Start Free Trial

worsnoptr

ASKER

I only have english selected and have only had english selected from the start and if i set my view to anything other then declined and any i only see the 2000 or so updates that i wan't to maintain. I have also rebooted the server and let the server sit over night and then re-ran the tools.

AutoIt_Airwolf

How do you know that the declined updates are still in your repository? They will remain listed in your database until they become superceded or obsolete (just like approved updates), because you can always go back and approve a declined update. This doesn't mean, however, that the declined updates have been downloaded to your repository. The entries for the declined updates are taking up a minimal amount of room in the database.

The only updates that will be removed from the database completely are updates that are superceded or obsolete.

worsnoptr

ASKER

How do you know that the declined updates are still in your repository?
because the wsus content folder is almost 25 gb
I need away to get rid of the extra 20 gb of junk before i push it out to my 25 other wsus servers. Anyone know away to get rid of the updates i declined after they were downloaded? I really don't want to have to rebuild my WSUS master and start over with my updates.

worsnoptr

ASKER

Does anyone know a good way to just purge all of the content from the database so i can just start over without re-installing WSUS? Can i just delete the folders in WSUS content or do i have to do something fancy?

AutoIt_Airwolf

I've only got 720 updates approved on my WSUS server, and the WSUSContent directory is over 20GB. If you've declined an update that was previously approved and downloaded, the server cleanup will remove it. I think you are hunting for a solution to a problem you don't have.

You can clear the database if you know SQL, but I'm sure manually deleting updates and modifying the database is "unsupported".

worsnoptr

ASKER

I have other WSUS servers that have only the updates the i want around 2000 and the database is about 6gb it is just my main server and my test WSUS servers that have all the extra content

worsnoptr

ASKER

I found something that works. I had to set my main WSUS server as a replica of one of my downstream servers that didn't have all the extra junk and syncronized it then i was able to run the wsusdebugtool.exe /tool:purgeunneededfiles and it deleted all of the extra drivers etc from my database so my database is back at 6gb on all of my servers. I assume that i could have run the clean up wizard instead of the wsusdebugtool but i already fixed the database on both of my problem servers.

I will give the points to Autolt_Airwolf for at least trying to help me out.