Solved

Could not delete the declined updates permanently

Posted on 2008-10-31
6
1,286 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
  • 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
How your wiki can always stay up-to-date

Quip doubles as a “living” wiki and a project management tool that evolves with your organization. As you finish projects in Quip, the work remains, easily accessible to all team members, new and old.
- Increase transparency
- Onboard new hires faster
- Access from mobile/offline

 
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

What Is Threat Intelligence?

Threat intelligence is often discussed, but rarely understood. Starting with a precise definition, along with clear business goals, is essential.

Join & Write a Comment

Suggested Solutions

Synchronize a new Active Directory domain with an existing Office 365 tenant
Ever wondered why sometimes your SQL Server is slow or unresponsive with connections spiking up but by the time you go in, all is well? The following article will show you how to install and configure a SQL job that will send you email alerts includ…
This video shows how to set up a shell script to accept a positional parameter when called, pass that to a SQL script, accept the output from the statement back and then manipulate it in the Shell.
This tutorial will walk an individual through the process of transferring the five major, necessary Active Directory Roles, commonly referred to as the FSMO roles to another domain controller. Log onto the new domain controller with a user account t…

706 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

13 Experts available now in Live!

Get 1:1 Help Now