Home
.. About WSUS Wiki

RSS

WSUS
.. WSUS FAQ
.. WSUS on SBS
.. WSUS Troubleshooting
.. WSUS News Groups
.. Known WSUS Issues
.. WSUS Links
.. WSUS Wish List

WSUS Documents
.. WSUS Deployment Guide
.. WSUS Installation Guide
.. WSUS Release Notes
.. WSUS Best Practice

SUS
.. SUS FAQ
.. What Is SUS
.. SUS Troubleshooting
.. SUS Links
.. SUS Known Issues
.. SUS FAQ
.. What Is SUS
.. SUS Troubleshooting
.. SUS Links
.. SUS Known Issues

Wiki Community
.. Wiki Contributors
.. I Love WSUS
.. WSUS Wiki Diary
.. Wiki Statistics
.. To Do Page

Miscellaneous Stuff
.. Other Resources
.. Do You Know?

Site Meter

Terms of Use
Trademarks
Privacy Statement

 

WSUS Database

This section explains the WSUS Database.

  1. WSUS Database Overiew
  2. Contents of the WSUS Database
  3. Types of databases supported by WSUS

WSUS Database
Each WSUS server makes use of a a database to function to hold server and update information. If there are multiple WSUS servers in your environment, you require multiple WUS databases. If you are installing WUS to a Windows Server 2003 system, you can install the database software (WMSDE) as part of the WSUS service installation. If you are installing WSUS to a Windows 2000 Server based system, you must first install database software.

Contents of the WSUS Database

The WUS database stores the following types of information:

  • WUS server configuration information
  • Metadata that describes each update
  • Detailed Information about clients, updates, and client interaction with updates
WUS server configuration includes how the synchronisation settings, etc. For each update that Microsoft publishes, there is metadata for that update that describes the update, lists the files required to install the update, and contains the relevant end user license agreement (EULA) for that update. Metadata is small, typically much smaller than the update itself, and is downloaded when you synchronise a WUS server. An update, however, is only downloaded when it has been approved for installation.

Types of database supported by WSUS

WSUS supports the following databases:

  1. Windows SQL Server 2000 Desktop Engine (WMSDE): WMSDE ships along with WSUS on Windows 2003 Server only. The advantage over MSDE is it doesn't have any limitation to size of database and no. of connections. However for WUS Beta 2, the WMSDE database is restricted to 2GB in size, a limitation that MS plans to lift at RTM.
  2. SQL Server 2000 Desktop Engine (MSDE): This is a free download, which is restricted to 2 GB of database size.
  3. SQL Server 2000: This is not free. If you are using SQL Server 2000 to hold your WSUS database, WSUS requires SQL Server 2000 with Service Pack 3a or later. Also, before you install WSUS, on this database, make sure nested triggers global server option is enabled on the SQL Server. Nested triggers is enabled by default. You just want to be sure it has not been turned off, because WSUS needs this option.
Database Recommendations
The free database like WMSDE/MSDE work acceptably - for Windows Server 2003: WMSDE is the recommended database software option while for Windows 2000, MSDE is the recommended database software option.

NOTES
  1. Each WSUS server requires its own database - if there are multiple WUS servers in your environment, you must have multiple WSUS databases.
  2. WSUS does not support multiple WUS databases on a single computer running SQL Server.
  3. Managing WSUS by accessing data directly in the database is not supported. Instead you can use WSUS API, that are designed for such purpose.

Last Modified 3/22/05 8:17 AM

Hide Tools

Site
Changes
Index
Search

User
Log In
Register