WSUS Database Maintenance

Step 1 Connect to SQL management studio and connect to SUSDB\\.\pipe\MSSQL$MICROSOFT##SSEE\sql\queryCopy below script and change the adminname parameter to your user name and parameter (@adminName=N’domain\user) Step 2 Step 3 Step 4 Step 5 Run the normal Server Wizard from the WSUS Management Console. Optional Automation If you’d like to automatically run the WSUS maintenance tasks, refer to … Read more

WSUS 2012 fix for 2008R2 clients

The file wsus3setup.cab is missing for requesting Clients. I have a Workaround to fix it: Ive searched for the wsus3setup.cab file on my wsus 2012 Server and found the following search result Then I’ve copied it to the self created Folder Win7SP1 under: C:\Program Files\Update Services\SelfUpdate\WSUS3\x64 Windows update error 0x80244010, means WU_E_PT_EXCEEDED_MAX_SERVER_TRIPS and happens when a … Read more

Reinstalling WSUS

Install-WindowsFeature -Name UpdateServices-Services,UpdateServices-DB -IncludeManagementTools You can get away with not uninstalling WSUS entirely. Stop the related services, delete the DB and run the post-install. .\wsusutil.exe postinstall SQL_INSTANCE_NAME=”DC1\SQL2008″ It’s also recommended to delete the MMC console data as that can sometimes prevent the postinstall from creating the database. This can be found here: Try removing the … Read more

Recreating the SUSDB and WSUS Content folder for a Windows Server 2012 based computer

1. Open PowerShell as admin. 2. Stop the WSUS service and IIS Service with the following command: stop-service WSUSService, W3SVC Verify that both are stopped by running get-service WSUSService, W3SVC It should look something like this: 3. Open SQL Server Management Studio and connect to the instance for SUSDB. How you connect via SQL Server Management … Read more