Hi Pantos,
What is the structure of your WSUS? If your current environment has only one WSUS, it is recommended to uninstall the current WSUS and reinstall it. In my opinion, uninstalling and reinstalling the WSUS role will solve the current problem more quickly.
To remove WSUS completely, you need to:
1.
Remove the following server roles and features through Server Manager:
Roles: Windows Server Update Server
features: Windows Server Update Services Tools(at Remote Server Administration Tools -> Role Administration Tools)
Follow the wizard prompts to complete the deletion. Then restart the server.
2.
After the server is restarted, manually delete the folder or file of the following path:
C:\WSUS (this depends on where you choose to install WSUS)
C:\Program Files\Update Services
3.
Delete database files
If you use SQL Server Management Studio to delete a database, you can try as follow.
In Object Explorer, connect to an instance of the SQL Server Database Engine, and then expand that instance. Expand Databases, right-click the database to delete, and then click Delete. Confirm the correct database is selected, and then click OK.
If you use a WID database, it is recommended to delete the following path folders:
C:\Windows\WID
4.
In the IIS Information Services (IIS) Manager, manually remove the WSUS Administration site. Then restart the server.
If the response is helpful, please click "Accept Answer" and upvote it.