WSUS Database instance - How to Flush?

I upgraded from 2.0 to 3.0 before a while. There were too many unwanted updates and I am doing a dbcc shrinkdatabase. My updates, accepts and declines are all in a mess. Can I flush the database and recreate it, afresh?

Server OS: SBS 2003
LVL 1
smtwklaAsked:
Who is Participating?
 
Philip ElderConnect With a Mentor Technical Architect - HA/Compute/StorageCommented:
Declined will stay declined. In the WSUS console set the view in All Updates to Declined only. Highlight them all and change their status to unapproved. Then go from there.
Philip
0
 
Philip ElderConnect With a Mentor Technical Architect - HA/Compute/StorageCommented:
In the WSUS manager under options: Server Cleanup Wizard.
Start from the BOTTOM up ONE at a TIME.
The top one on the list will take the longest and may even stall a couple of times. Rerun it.
Philip
0
 
smtwklaAuthor Commented:
I am doing it. I am also using WSUSDebugTool to cleanup.

But for a while, I have not approved / managed updates, even critical ones. Now that I am cleaning up, It seems that updates that have not been approved for a while are deleted by the clean up process. How do I ensure that after cleanup, all critical updates that are at the moment not installed are properly applied?
0
Keep up with what's happening at Experts Exchange!

Sign up to receive Decoded, a new monthly digest with product updates, feature release info, continuing education opportunities, and more.

 
smtwklaAuthor Commented:
Is it possible to instruct WSUS to re-detect what updates are required for which system? Kinda a reset?
0
 
Philip ElderConnect With a Mentor Technical Architect - HA/Compute/StorageCommented:
Any required updates will be detected on the workstations and servers and show up for approval.
Philip
0
 
smtwklaAuthor Commented:
"Any required updates will be detected on the workstations and servers and show up for approval.
Philip"

Even those I had automaticaly declined during the cleanup using cleanup wiz / wsusdebugtool / wsustool ?
0
All Courses

From novice to tech pro — start learning today.