WSUS | error 800B0001

WindoesUpdate.log says: Digital Signatures on file C:\Windows\SoftwareDistribution\SelfUpdate\wuident.cab are not trusted   Be sure your WSUS installation is fully patched: https://wsus.de/de/FAQ -> 44 WSUS auf Windows Server 2008 / 2008 R2 WSUS 3.0 (RC): Build 3.0.6000.318 WSUS 3.0 (RTW): Build 3.0.6000.374 WSUS 3.0 (SP1): Build 3.1.6001.65 WSUS 3.0 (SP1) + KB954960: Build 3.1.6001.66 WSUS 3.0 (SP2 […]

WSUS | Database maintenance

/****************************************************************************** This sample T-SQL script performs basic maintenance tasks on SUSDB 1. Identifies indexes that are fragmented and defragments them. For certain tables, a fill-factor is set in order to improve insert performance. Based on MSDN sample at http://msdn2.microsoft.com/en-us/library/ms188917.aspx and tailored for SUSDB requirements 2. Updates potentially out-of-date table statistics. ******************************************************************************/ USE SUSDB; GO SET […]

WSUS | database cleanup

After executing this run a mainenance job to re-index your stuff. DECLARE @var1 INT DECLARE @msg nvarchar(100) CREATE TABLE #results (Col1 INT) INSERT INTO #results(Col1) EXEC spGetObsoleteUpdatesToCleanup DECLARE WC Cursor FOR SELECT Col1 FROM #results OPEN WC FETCH NEXT FROM WC INTO @var1 WHILE (@@FETCH_STATUS > -1) BEGIN SET @msg = ‘Deleting ‘ + CONVERT(varchar(10), […]

WSUS | MMC timeout

Open the SQL Server Management Studio. Right click your service. Open Properties. Select Connections. Tune the Timeout value from 600 to a much higher value or set it to 0 for no timeout.