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?
I wear a lot of hats...

"The solutions and answers provided on Experts Exchange have been extremely helpful to me over the last few years. I wear a lot of hats - Developer, Database Administrator, Help Desk, etc., so I know a lot of things but not a lot about one thing. Experts Exchange gives me answers from people who do know a lot about one thing, in a easy to use platform." -Todd S.

Philip ElderTechnical 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
smtwklaAuthor Commented:
Is it possible to instruct WSUS to re-detect what updates are required for which system? Kinda a reset?
0
Get your problem seen by more experts

Be seen. Boost your question’s priority for more expert views and faster solutions

Philip ElderTechnical 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
Philip ElderTechnical 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

Experts Exchange Solution brought to you by

Your issues matter to us.

Facing a tech roadblock? Get the help and guidance you need from experienced professionals who care. Ask your question anytime, anywhere, with no hassle.

Start your 7-day free trial
It's more than this solution.Get answers and train to solve all your tech problems - anytime, anywhere.Try it for free Edge Out The Competitionfor your dream job with proven skills and certifications.Get started today Stand Outas the employee with proven skills.Start learning today for free Move Your Career Forwardwith certification training in the latest technologies.Start your trial today
Windows Server 2003

From novice to tech pro — start learning today.

Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.