question

GaryBeamer-5253 avatar image
0 Votes"
GaryBeamer-5253 asked RitaHu-MSFT answered

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

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.



135595-image.png



windows-server-update-services
image.png (118.9 KiB)
5 |1600 characters needed characters left characters exceeded

Up to 10 attachments (including images) can be used with a maximum of 3.0 MiB each and 30.0 MiB total.

PierreLucGiguere-5297 avatar image
0 Votes"
PierreLucGiguere-5297 answered AJTek-Adam-J-Marshall commented

Hi,

I would recommend doing 2 things:

  1. Run the Server cleanup Wizard
    https://docs.microsoft.com/en-us/windows-server/administration/windows-server-update-services/manage/the-server-cleanup-wizard

  2. Reindex the WSUS datase:
    https://docs.microsoft.com/en-us/troubleshoot/mem/configmgr/reindex-the-wsus-database

Please let me know if my solution worked for you.


· 2
5 |1600 characters needed characters left characters exceeded

Up to 10 attachments (including images) can be used with a maximum of 3.0 MiB each and 30.0 MiB total.

When ever I run the server clean up wizard to remove computers it also times out. I have reindexed this thing twice

0 Votes 0 ·

Are you performing the proper WSUS maintenance? There's more to it than just the Server Cleanup Wizard (SCW), and running the SQL Indexing script, including but not limited to declining superseded update, managing products and classifications, etc.?

https://www.ajtek.ca/wsus/how-to-setup-manage-and-maintain-wsus-part-8-wsus-server-maintenance/

0 Votes 0 ·
AJTek-Adam-J-Marshall avatar image
0 Votes"
AJTek-Adam-J-Marshall answered GaryBeamer-5253 commented
· 1
5 |1600 characters needed characters left characters exceeded

Up to 10 attachments (including images) can be used with a maximum of 3.0 MiB each and 30.0 MiB total.

I am attempting to locate the bad computer. However, I am unsure as how to locate the MMC console crash file as it references. I have everything else ready but can not find that crash log.

0 Votes 0 ·
RitaHu-MSFT avatar image
1 Vote"
RitaHu-MSFT answered

@GaryBeamer-5253
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.
136101-12.png


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.


12.png (11.2 KiB)
5 |1600 characters needed characters left characters exceeded

Up to 10 attachments (including images) can be used with a maximum of 3.0 MiB each and 30.0 MiB total.