Forum Discussion
WSUS DB Maintenance
Is there a recommended maintenance script or set of tasks for WSUS on Windows Server 2019?
- Haven't done much with WSUS the last few years, but I liked https://github.com/awarre/Optimize-WsusServer
- Did that work for you?
- Hi shocko I would recommend this script as it does a lot of things WSUS cannot do on its own.
You will be amazed and it is worth every penny of the annual subscription alone for the time saving.
There won't be a better and more comprehensive script on the net you will find. Promised.
https://www.ajtek.ca/
- Haven't done much with WSUS the last few years, but I liked https://github.com/awarre/Optimize-WsusServer
- Seems more holistic in the sense of looking at the WSUS app layer rather than pure DB layer.
- It does a lot.
Optimizing SQL or WID database (I recommend not to use the WID due to ram and CPU limits technically it's an unpatched SQL 2012 LocalDB,
WSUS,
IIS,
logging.
It also fixes the wrong OS names on database level as well as sufficiently compress and purge old updates from the database.
In typical environment this saves you thousands or hundred of thousands update metadata.
As said there's nothing better for WSUS DB than this. You won't be disappointed. Tried a lot of free scripted solutions before. WAM was once free too.
You will never have to worry about having too many Updates, old Updates, uneeded Updates. You can auto approve all and WAM takes care that the DB and repository doesn't explode.
Btw. For most customers I don't use WSUS to save any updates. As this does not make sense in modern environments due to delivery optimization.
