WSUS Database maintenance

Install ‘SQL Server Management Studio Express’ Run ‘SQL Server Management Studio Express’ as Administrator. Server is \\.\pipe\MICROSOFT##WID\tsql\query Backup your SUSDB. Check this: https://docs.microsoft.com/de-de/troubleshoot/mem/configmgr/wsus-maintenance-guide https://docs.microsoft.com/en-us/troubleshoot/mem/configmgr/wsus-maintenance-guide Short: Create a project, Create custom indexes (ONLY BEFORE YOUR FIRST REINDEXING, once in a databases lifetime), reindex (https://docs.microsoft.com/de-de/troubleshoot/mem/configmgr/reindex-the-wsus-database https://docs.microsoft.com/en-us/troubleshoot/mem/configmgr/reindex-the-wsus-database) HINT: Never distribute drivers via WSUS. Exclude them in WSUS. I […]