WSUS Truncate tbEventInstance table - awarre/Optimize-WsusServer GitHub Wiki

Description

Windows Server Update Services (WSUS) logs all client communication events to its database in the tbEventInstance table.

The size of this log can eventually cause a number of database errors including:

  1. Reaching the maximum 10GB database size for Microsoft SQL Express.

    System.Data.SqlClient.SqlException -- Could not allocate space for object 'dbo.XXX' in database 'SUSDB' because the 'PRIMARY' filegroup is full. Create disk space by deleting unneeded files, dropping objects in the filegroup, adding additional files to the filegroup, or setting autogrowth on for existing files in the filegroup.

  2. Reaching over 1 million rows.

    WARNING: Failed to upload events to the server with hr = 80244008

This will cause Windows clients to be unable to update, WSUS server to be unable to synchronize, and the WSUS graphical interface to lockup or timeout.

Resolution

The tbEventInstance table in the SUSDB database can be safely truncated to restore functionality to WSUS.

truncate table tbEventInstance

References