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

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

Checking for updates stuck

Update Windows Update Agent (Windows 8.1/7 SP 1) Recently windows have released an update for its windows update agent which have a couple of bug fixes. The download links for the same are given below Windows 8.1 https://support.microsoft.com/en-in/kb/3138615 Windows 7 SP 1 https://support.microsoft.com/kb/3138612 You’ll see a MSU file in your downloads folder when it’s completed. … Read more