A WSUS 3.0 SP2 Installation on a site I inherited has a huge database by now.
This site used to have several generations/variations of client/server Windows installations, and several thousands of approved updates for the <80 machines. Now all the machines have been updated/harmonized to 1 generation of Windows, and 2 Generations of Office (soon to be one).
I have edited the "Products and Classifications" and ran the "Server Cleanup Wizard every time an old generation/SP-Level was dropped. The Wizard each time deleted many files from the WSUSContent folder.
Now I am down to <700 approved updates, yet the WSUSContent folder and the database are still huge and slow. 11GiB+ and 5GiB+.
Can I, without having to reinstall WSUS and the updates for it, "clear" the database, delete all WSUSContent/*, and start fresh with 0 Approvals/PCs?
Most of the updates in the database have been rolled into updated installation files anyway, so I hope to end up with a much leaner/faster database without old logs about ancient updates.
I know about wsusutil reset
, but this only "reset"s the WSUSContent, not the Database?
So, I think, my core question is: "How do get an untouched WSUS-DB for an existing installation"?