Solved

WSUS Database instance - How to Flush?

Posted on 2008-10-21
6
1,392 Views
Last Modified: 2012-06-21
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
0
Comment
Question by:smtwkla
  • 3
  • 3
6 Comments
 
LVL 38

Assisted Solution

by:Philip Elder
Philip Elder earned 500 total points
ID: 22771799
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
 
LVL 1

Author Comment

by:smtwkla
ID: 22772644
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
 
LVL 1

Author Comment

by:smtwkla
ID: 22772649
Is it possible to instruct WSUS to re-detect what updates are required for which system? Kinda a reset?
0
Backup Your Microsoft Windows Server®

Backup all your Microsoft Windows Server – on-premises, in remote locations, in private and hybrid clouds. Your entire Windows Server will be backed up in one easy step with patented, block-level disk imaging. We achieve RTOs (recovery time objectives) as low as 15 seconds.

 
LVL 38

Assisted Solution

by:Philip Elder
Philip Elder earned 500 total points
ID: 22772666
Any required updates will be detected on the workstations and servers and show up for approval.
Philip
0
 
LVL 1

Author Comment

by:smtwkla
ID: 22775205
"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
 
LVL 38

Accepted Solution

by:
Philip Elder earned 500 total points
ID: 22777594
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

Featured Post

How to run any project with ease

Manage projects of all sizes how you want. Great for personal to-do lists, project milestones, team priorities and launch plans.
- Combine task lists, docs, spreadsheets, and chat in one
- View and edit from mobile/offline
- Cut down on emails

Join & Write a Comment

Suggested Solutions

Introduction At 19:33 (UST) on Tuesday 21st September the long awaited email arrived with the subject title of “ANNOUNCING THE AVAILABILITY OF WINDOWS SBS 7 PREVIEW”.  It was time to drop whatever I was doing and dedicate as much bandwidth as possi…
A quick step-by-step overview of installing and configuring Carbonite Server Backup.
Excel styles will make formatting consistent and let you apply and change formatting faster. In this tutorial, you'll learn how to use Excel's built-in styles, how to modify styles, and how to create your own. You'll also learn how to use your custo…
Access reports are powerful and flexible. Learn how to create a query and then a grouped report using the wizard. Modify the report design after the wizard is done to make it look better. There will be another video to explain how to put the final p…

705 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question

Need Help in Real-Time?

Connect with top rated Experts

14 Experts available now in Live!

Get 1:1 Help Now