Remove updates from wsus

Fortunately, the error gives you exact location table where this constraint is violated, so you can adjust one of the queries in the batch above to delete references in any other tables.

This should be pretty straight forward and self-explanatory. You will want to make sure that your WSUS systems are functioning as expected before declaring victory. If you use PowerShell, deleting declined updates using this assembly might look something like this:. This runs quite well, and does the job described earlier in the SQL scripts, perhaps in a more elegant and quite possibly in a more supported way; that said, deleting updates through the API is a very slow process — the rate I was seeing was around updates an hour.

SQL scripts do the job many times quicker. Probably the best way to deal with this issue is to setup this PowerShell script to run nightly, along with database index defrags. See Downloads page for the scripts I use. You are commenting using your WordPress. You are commenting using your Google account. You are commenting using your Twitter account. You are commenting using your Facebook account. Notify me of new comments via email. Toggle SideBar. Success Center. Select your Preferred Language from the below list.

Remove unneccessary updates from the WSUS server If you are experiencing problems with your drive consuming too much space on the WSUS server, perform the steps in this article to run the Server Cleanup Wizard and remove unnecessary updates based on rules. Publishing Information First Published Date. Last Published Date. Information Title. Remove unneccessary updates from the WSUS server. If you are experiencing any of the following problems 1.

WSUS connection timeout errors 4. Most clients failed to install updates with possibly different errors. This will free up space on your disk and clean up the WSUS server to some extent. Environment Select the products and versions this article pertains too. Patch Manager 2. In the Task Options Wizard, run the task now or create a schedule for the task.

Complete the wizard. Did you know? Solarwinds offers fully functional free trials of all of our products, from network and systems management to IT Security and Database Monitoring Free Trials and Downloads. Related Articles Info. Quick access. Search related threads. Remove From My Forums.

Answered by:. Archived Forums. Sign in to vote. Friday, March 9, AM. Hello You can use this procedure 1. Best regards Eric.