Windows Update Server - Deleting old computers and getting SQL database error

Question

I have windows server 2012 R2 with the original database version that comes with the software install. I installed it as the Windows internal database. When ever I try to delete a computer that has failed updates from the WSUS wizard or screen the connection to the database drops. Now I I have loaded SQL Managment Studio and connected to the SUSDB in an attempt to delete computers from there. However, now I get this error. What do I need to do so that I can remove these devices? This happens even if I try to delete one at a time. I also only seem to get this issue deleting failed computers. Not nearly as much if at all when deleting a machine that has successfully install the updates or no errors.

Answer 1

@Gary Beamer
Thanks for your posting on Q&A.

Please run the below PowerShell script to remove the obsolete computers.
https://github.com/djdomi/WSUS-Cleanup-Scripts/blob/master/wsus-cleanup-updates-v4.ps1

We recommend to run the script to avoid Server Cleanup Wizard timed-out.

Hope the above will be helpful. Please feel free to keep us in touch if there are any updates of the case.

Regards,
Rita

---

If the response is helpful, please click "Accept Answer" and upvote it.
Note: Please follow the steps in our documentation to enable e-mail notifications if you want to receive the related email notification for this thread.

Answer 2

Hi,

I would recommend doing 2 things:

1. Run the Server cleanup Wizard
   https://learn.microsoft.com/en-us/windows-server/administration/windows-server-update-services/manage/the-server-cleanup-wizard
2. Reindex the WSUS datase:
   https://learn.microsoft.com/en-us/troubleshoot/mem/configmgr/reindex-the-wsus-database

Please let me know if my solution worked for you.

Answer 3

Also look at : https://www.ajtek.ca/wsus/are-your-computers-to-blame-for-the-wsus-mmc-console-crashing/