WSUS database

Exploring the WSUS Windows Internal Database

Správa WSUS databaze

Note: You must install .NET Framework 2.0 and MSXML 6.0 Parser before you install SSMSE 2008 R2.

Note: You must install .NET Framework and MSXML 6.0 Parser before you install SSMSE 2005

1. Download Microsoft SQL Server Management Studio Express 2008 R2 from here or SSMSE 2008 R2 RTM.  Make sure you select the x86 or x64 version depending on your server architecture.
2. Install SQL Management Studio by selecting all defaults.
3. Open SQL Management Studio by selecting Start – All Programs – Microsoft SQL Server 2005 and selecting SQL Server Management Studio Express.
4. At the “Connect to Server” dialog, in the Server name field enter the  following string:
\\.\pipe\MSSQL$MICROSOFT##SSEE\sql\query

5. At this point SQL Management Studio Express will make a connection to the Windows Internal Database using a named pipes connection (one of the limitations of Windows Internal Database).
6. Expand Databases and select SUSDB to explore tables, views, permissions, etc as you would as if you were using full SQL.
   
7. It is important to remember that editing the SUSDB tables, is not supported by Microsoft.

https://technet.microsoft.com/cs-cz/library/ms365247(v=sql.105).aspx

Zdroj

WSUS Content folder

What to do when your WSUSContent folder grows too large

Jak zmenšit WSUS adresář

How to Do a Reset WSUS:

Note: You may want to execute the procedure below during off hours as your WSUS server will be downloading quite a bit of data.

1. Correct any settings above or disapprove any unneeded updates.
2. Close any open WSUS consoles.
3. Go to Administrative Tools – Services and STOP the Update Services service.
4. In Windows Explorer browse to the WSUSContent folder (typically D:\WSUS\WSUSContent or C:\WSUS\WSUSContent)
5. Delete ALL the files and folders in the WSUSContent folder.
6. Go to Administrative Tools – Services and START the Update Services service.
7. Open a command prompt and navigate to the folder: C:\Program Files\Update Services\Tools.
8. Run the command WSUSUtil.exe RESET

-This command tells WSUS to check each update in the database, and verify that the content is present in the WSUSContent folder. As it finds that the content is not present in the folder, it executes a BITS job to download the content from Microsoft. This process takes quite a bit of time and runs in the background.

How do you tell when the process is complete?

Other than noticing that the WSUSContent folder is no longer growing you can also check the SoftwareDistribution.log:

C:\Program Files\Update Services\LogFiles\SoftwareDistribution.log

When you start the reset process, you should see a line towards the bottom of the log which looks like this:

WsusService.13  ExecutionContext.runTryCode     State Machine Reset Agent Starting

After waiting for some time, check the log again and search for the text “State Machine Reset Agent Finished”

WsusService.13  ExecutionContext.runTryCode     State Machine Reset Agent Finished

Zdroj