How can I safely remove WSUS feature completely and reinstall it as uninstalling the site role and reinstalling the WSUS service and SCCM role does not work as the settings from the first installation and configuration of WSUS are retained
This is how you do it. What do you mean the "settings are retained". If you fully uninstalled WSUS the settings cannot be retained because they're stored in the WSUS database. Did you DELETE the WSUS database?
I found this suggestion but will this remove the SCCM database?
No.
But it also won't help unless WSUS is actually installed in the Windows Internal Database. If you installed WSUS on the Site Server, the normal configuration would be to install the WSUS database in the Configuration manager instance of SQL Server, rather
than install a *second* database engine on the same machine.
But before you dig deeper into that rathole, let's back up a step and talk about the problem you're trying to solve. **WHY** are you interested in "clearing the WSUS database"?
Lawrence Garvin, M.S., MCSA, MCITP:EA, MCDBA
SolarWinds Head Geek
Microsoft MVP - Software Packaging, Deployment & Servicing (2005-2014)
My MVP Profile: http://mvp.microsoft.com/en-us/mvp/Lawrence%20R%20Garvin-32101
http://www.solarwinds.com/gotmicrosoft
The views expressed on this post are mine and do not necessarily reflect the views of SolarWinds.