Solved

Could not delete the declined updates permanently

Posted on 2008-10-31
6
1,287 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
Three Reasons Why Backup is Strategic

Backup is strategic to your business because your data is strategic to your business. Without backup, your business will fail. This white paper explains why it is vital for you to design and immediately execute a backup strategy to protect 100 percent of your data.

 
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

PRTG Network Monitor: Intuitive Network Monitoring

Network Monitoring is essential to ensure that computer systems and network devices are running. Use PRTG to monitor LANs, servers, websites, applications and devices, bandwidth, virtual environments, remote systems, IoT, and many more. PRTG is easy to set up & use.

Question has a verified solution.

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

Find out how to use Active Directory data for email signature management in Microsoft Exchange and Office 365.
Last week, our Skyport webinar on “How to secure your Active Directory” (https://www.experts-exchange.com/videos/5810/Webinar-Is-Your-Active-Directory-as-Secure-as-You-Think.html?cid=Gene_Skyport) provided 218 attendees with a step-by-step guide for…
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 from a Windows Server 2008 domain controller to a Windows Server 2012 domain controlle…
Viewers will learn how the fundamental information of how to create a table.

773 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