Initial SUSDB.mdf file after a virgin installation was 8,340KB
During the initial setup of WSUS it goes away and downloads update information from Microsoft Update (You press Start Connecting and wait quite a while). After this process completes, but before you pressed next the size of SUSDB.mdf was 35,008 KB.
A backup of a SUSDB taken after a virgin installation of WSUS 3.0 SP2 but before any configuration.]
Warning : As of 18-09-2015 I’ve not used this to fix a bloated WSUS server, but the next one I come accross it is my attention to
- Stop the Update Services service.
- Empty the contents of \WSUS\WsusContent
- Restore this backup of the SUSDB database
- Start the Update Services service.
- See what happens (initial configuration hopefully?!)
If you do this before I do, please let me know how you get on.
Warning: this is an unsupported procedure. If you do it, you’re doing it at your own risk.
After pressing next you ….
You specified only English updates
You specified the following Products
- Microsoft Security Essentials
- MS Security Essentials
- Security Essentials
- Silverlight
- Silverlight
- Windows
- Windows 7
- Windows Server 2008 (not R2!)
You specified the following Classifications
- Critical Updates
- Definition Updates
- Security Updates
After initial setup you let WSUS finish it’s first Synchronization. It completes with 2293 security updates & 221 critical updates awaiting approval. No clients are yet registered. SUSDB.mdf is now 632,000 KB.
Ran WsusSmartApprove before any clients reported in. No updates approved.
C:\SCS\windows-server-tools\WSUS\WsusSmartApprove-v1.0.5>WsusSmartApprove.exe /norunset WSUS Smart Approve 1.0.5.0 (http://wsussmartapprove.codeplex.com) (C)Copyright 2009-2014 DHGMS Solutions. Some Rights Reserved. Connecting to server: localhost:8530 Performing "No Run Set" rule: Getting root target group: succeeded. Checking Superseded Updates: Checking Stale Updates: No updates required. Getting classifications Getting list of updates for : Applications No updates required. Getting list of updates for : Critical Updates No updates required. Getting list of updates for : Definition Updates No updates required. Getting list of updates for : Drivers No updates required. Getting list of updates for : Feature Packs No updates required. Getting list of updates for : Security Updates No updates required. Getting list of updates for : Service Packs No updates required. Getting list of updates for : Tools No updates required. Getting list of updates for : Update Rollups No updates required. Getting list of updates for : Updates No updates required.
Configured one server and one workstation to use WSUS and they turned up in the WSUS console as computers with “no status”.
Ran “wuauclt /reportnow” (taking on board https://social.technet.microsoft.com/Forums/windowsserver/en-US/19b5f65e-1418-463c-90bf-dffa9469effa/wuauclt-commands-to-force-reporting-of-status?forum=winserverwsus) and waited 30minutes.
Checked again in the morning, and them had a percentage installed.
Re-ran WsusSmartApprove now I had computers registered and it approved some updates (presumably ones the machines needed).
c:\SCS\windows-server-tools\WSUS\WsusSmartApprove-v1.0.5>WsusSmartApprove.exe /norunset WSUS Smart Approve 1.0.5.0 (http://wsussmartapprove.codeplex.com) (C)Copyright 2009-2014 DHGMS Solutions. Some Rights Reserved. Connecting to server: localhost:8530 Performing "No Run Set" rule: Getting root target group: succeeded. Checking Superseded Updates: Checking Stale Updates: No updates required. Getting classifications Getting list of updates for : Applications No updates required. Getting list of updates for : Critical Updates 1 updates required. Update for Windows Server Update Services 3.0 SP2 for x64-based Systems (KB2720211). Update for Windows Server Update Services 3.0 SP2 for x64-based Systems (KB2720211): approved for install. Update for Windows Server Update Services 3.0 SP2 for x64-based Systems (KB2720211): approved for install. Update for Windows Server Update Services 3.0 SP2 for x64-based Systems (KB2720211): approved for install. Update for Windows Server Update Services 3.0 SP2 for x64-based Systems (KB2720211): approved for install. Getting list of updates for : Definition Updates No updates required. Getting list of updates for : Drivers No updates required. Getting list of updates for : Feature Packs No updates required. Getting list of updates for : Security Updates 2 updates required. Security Update for Windows Server 2008 x64 Edition (KB2928120). Security Update for Windows Server 2008 x64 Edition (KB2928120): approved for install. Security Update for Windows Server 2008 x64 Edition (KB2928120): approved for install. Security Update for Windows Server 2008 x64 Edition (KB2928120): approved for install. Security Update for Windows Server 2008 x64 Edition (KB2928120): approved for install. Security Update for Windows 7 for x64-based Systems (KB2928120). Security Update for Windows 7 for x64-based Systems (KB2928120): approved for install. Security Update for Windows 7 for x64-based Systems (KB2928120): approved for install. Security Update for Windows 7 for x64-based Systems (KB2928120): approved for install. Security Update for Windows 7 for x64-based Systems (KB2928120): approved for install. Getting list of updates for : Service Packs No updates required. Getting list of updates for : Tools No updates required. Getting list of updates for : Update Rollups No updates required. Getting list of updates for : Updates No updates required.
sdsds