Solved

Could not delete the declined updates permanently

Posted on 2008-10-31
6
1,291 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
Independent Software Vendors: We Want Your Opinion

We value your feedback.

Take our survey and automatically be enter to win anyone of the following:
Yeti Cooler, Amazon eGift Card, and Movie eGift Card!

 
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

Free Tool: Subnet Calculator

The subnet calculator helps you design networks by taking an IP address and network mask and returning information such as network, broadcast address, and host range.

One of a set of tools we're offering as a way of saying thank you for being a part of the community.

Question has a verified solution.

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

Why is this different from all of the other step by step guides?  Because I make a living as a DBA and not as a writer and I lived through this experience. Defining the name: When I talk to people they say different names on this subject stuff l…
In this article we will learn how to fix  “Cannot install SQL Server 2014 Service Pack 2: Unable to install windows installer msi file” error ?
Viewers will learn how the fundamental information of how to create a table.
Are you ready to implement Active Directory best practices without reading 300+ pages? You're in luck. In this webinar hosted by Skyport Systems, you gain insight into Microsoft's latest comprehensive guide, with tips on the best and easiest way…

730 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