Solved

Could not delete the declined updates permanently

Posted on 2008-10-31
6
1,292 Views
Last Modified: 2012-05-05
Hi,

We have wsus 3.0 and we are trying to remove some 2000 unused,expired,declined and superseeded updates permanently....

(i) We tried using server cleanup wizard and it runs successfully but deletes 0 updates.
( ii)I also Downloaded,  the WSUS Server Diagnostic Tool and  Run the Server Diagnostic Tool with the PurgeUnneededFiles switch, but still no joy.
(iii) I also removed unneeded languages or product classifications that arent supported on our network.
(iv) I also tried wsusutil.exe deleteunneededrevisions but no luck
(v) I checked the content of the downloaded update files in C:\windows\WSUS\WSUSContent and it looks like it is deleted from the MSDE datbase but still my wsus console shows "2000 updates and 2500 total".....

How i do remove these updates permanently and my wsus console shows the actual updates ?
Can somebody guide me with some scripts to run against the MSDE database to clean,repair and shrink the database and log file.


 
0
Comment
Question by:sk_raja_raja
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
  • 3
  • 3
6 Comments
 
LVL 18

Assisted Solution

by:Don S.
Don S. earned 300 total points
ID: 22855622
Declining an update will allow cleanup to remove the content (or prevent it from downloading in the first place) it wil not, however allow cleanup to remove the item from the database.
0
 
LVL 18

Author Comment

by:sk_raja_raja
ID: 22855720
ok...but how do i permanently delete the updates from the Database..... i just want to see the latest updates from Jan 2008 (around 500) on my wsus console.
0
 
LVL 18

Expert Comment

by:Don S.
ID: 22868778
You can't.  
0
Office 365 Training for Admins - 7 Day Trial

Learn how to provision tenants, synchronize on-premise Active Directory, implement Single Sign-On, customize Office deployment, and protect your organization with eDiscovery and DLP policies.  Only from Platform Scholar.

 
LVL 18

Author Comment

by:sk_raja_raja
ID: 22868809
No, I dont agree that...there should be some way to delete it form MSDE...right ?
0
 
LVL 18

Assisted Solution

by:Don S.
Don S. earned 300 total points
ID: 22869401
If you study how MS builds and maintains it's supercedance hirearchy from it's master servers, you'll understand why they don't provide for deleting declined updates.  It's not that you physically can't, it's that it will break the chain and WSUS will either fix it by re downloading the missing update headers or just stay broken.  If you want to delete declined headers, you're pretty much on your own - MS won't provide a way to do it.  It's just the headers that stay, not the content.  The content is what takes up all the space.  I would really suggest you leave it alone.
0
 
LVL 18

Accepted Solution

by:
sk_raja_raja earned 0 total points
ID: 22897255
Oh is it..I never knew that....can you send me some MS links or articles that clearly explains this....... It may be useful for me to convince my boss :):):)
0

Featured Post

On Demand Webinar - Networking for the Cloud Era

This webinar discusses:
-Common barriers companies experience when moving to the cloud
-How SD-WAN changes the way we look at networks
-Best practices customers should employ moving forward with cloud migration
-What happens behind the scenes of SteelConnect’s one-click button

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

A project that enables an administrator to perform actions within a user session context not just at the time of login but any time later on day(s) or week(s) later.
Active Directory security has been a hot topic of late, and for good reason. With 90% of the world’s organization using this system to manage access to all parts of their IT infrastructure, knowing how to protect against threats and keep vulnerabil…
Viewers will learn how to use the SELECT statement in SQL and will be exposed to the many uses the SELECT statement has.
This video shows how to use Hyena, from SystemTools Software, to update 100 user accounts from an external text file. View in 1080p for best video quality.

688 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