?
Solved

Could not delete the declined updates permanently

Posted on 2008-10-31
6
Medium Priority
?
1,294 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 1200 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
Microsoft Certification Exam 74-409

Veeam® is happy to provide the Microsoft community with a study guide prepared by MVP and MCT, Orin Thomas. This guide will take you through each of the exam objectives, helping you to prepare for and pass the examination.

 
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 1200 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

Get real performance insights from real users

Key features:
- Total Pages Views and Load times
- Top Pages Viewed and Load Times
- Real Time Site Page Build Performance
- Users’ Browser and Platform Performance
- Geographic User Breakdown
- And more

Question has a verified solution.

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

After seeing many questions for JRNL_WRAP_ERROR for replication failure, I thought it would be useful to write this article.
What if you have to shut down the entire Citrix infrastructure for hardware maintenance, software upgrades or "the unknown"? I developed this plan for "the unknown" and hope that it helps you as well. This article explains how to properly shut down …
Via a live example, show how to shrink a transaction log file down to a reasonable size.
Viewers will learn how the fundamental information of how to create a table.
Suggested Courses

771 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