Link to home
Start Free TrialLog in
Avatar of Vikash Mohan
Vikash MohanFlag for United Kingdom of Great Britain and Northern Ireland

asked on

WSUS Taking up too much space

Hello,

One of our customers who uses WSUS are running very low on disk space, currently they average out between 7-15GB free. This is resulting in my backups failing.

I have tried running WSUS Server cleanup wizard (currently uses 20GB) with no change to disk space, the console itself keeps disconnecting when i am trying to sort out All updates with the following parameters;

Approval - Any except declined
Status -  Any

Then i try to sort updates in superseded order, so i can decline them.

I suppose the question i am asking is I need to delete the wsus database file "SUSDB.mdf" which is taking up 20gb of space.

I have attached a few things that may be useful including things that i have tried and the disconnection error i get with thew wsus console., please don't hesitate to ask for more. I have listed below some of the server specs including WSUS information;

Windows SBS Server 2008 SP2
 - Intel Xeon CPU E5520@2.27GHz
 - 8GB Ram

WSUS Console 3.0 SP1

I have tried the information in the following link with no luck;

http://www.bdhtechnology.com/help/wsus.php
Screenshot--8-.png
Avatar of x-men
x-men
Flag of Portugal image

try shrinking the SUSDB using SQL Management Studio.
Avatar of Vikash Mohan

ASKER

Thanks for the reply, I will try both of your solutions, but will they effect users whilst they are currently working?
WSUS is a repository for windows updates, it does not affect users working.
Currently running x-men application he offered, i shall let you know the results.
Hi

I run this weekly a script which then sends me an email with the results

@echo off
del c:\util\cleanup_history.txt

c:\util\wsus_cleanup_cl  serv010 f 80 superseded expired obsolete compress computers files

c:\util\febooti\febootimail -from admin01@mydomain.com -to support@mydomain.com,admin01@mydomain.com -msg "Open attachment for Report" -subj "SERV010 WSUS Server Weekly Cleanup" -dontupdate -attach cleanup_history.txt -smtp 192.168.1.26

exit



AS you can see I do not use the SQL portion of wsus cleanup since my wsus server database is running on a sql 2008 server I have maint plans that take care of the sql database

Hope this helps
ASKER CERTIFIED SOLUTION
Avatar of Don
Don
Flag of United States of America image

Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial
FYI,

 a little info on running WSUSutil.exe reset in this situation.

You would first be deleting the whole WSUSContent folder.

Then running the reset will re-download the entire content again(All approved updates)

This will not only take up some time, but will also use up alot of bandwidth.

You're better off moving the content to another larger volume.
Agree with dstewartjr ... you can shrink the .ldf safely without having to start over but if you have sufficient space on a data volume, move the database and repository using the supplied instructions.

HTH
Gary
We will be following the solutions you have given us from tomorrow (11/10/13) from 2pm, as our customer goes home early so we have the rest of the evening and thew weekend to do what we need, i will update you on Monday the results.
Thanks to all that provided solutions however the one we've picked as moving the WSUS content was more appropriate for the situation.

Thanks again!