WSUS Database is huge
Submitted by Dave Blair on Wed, 06/13/2018 - 18:31On an 2008 server I had a space issue. Unwilling or unable to upgrade I needed to find the client some more space on the drive.
Even after cleaning out the usual temp files etc. I still needed more.
I noticed the WSUS database ,mdb was one of the largests files at 26Gb.
-How to reduce the size safely-
Open the SQL manager,
enter "\\.\pipe\MSSQL$MICROSOFT##SSEE\sql\query" in the 'server' field and connect.
You will now be connected to the WSUS SUDB database!
WSUS logs everything it does to a table in this database.
We don't need to keep all of this.
The logs live in the table "tbEventInstance".
Delete all of these like this:
Click on the database name 'SUSDB'
Click 'New Query'
Type 'truncate table tbEventInstance' in to the Query Editor
Click the 'Execute' button - or press F5.