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
Vikash MohanTechnical DirectorAsked:
Who is Participating?
I wear a lot of hats...

"The solutions and answers provided on Experts Exchange have been extremely helpful to me over the last few years. I wear a lot of hats - Developer, Database Administrator, Help Desk, etc., so I know a lot of things but not a lot about one thing. Experts Exchange gives me answers from people who do know a lot about one thing, in a easy to use platform." -Todd S.

x-menIT super heroCommented:
try shrinking the SUSDB using SQL Management Studio.
0
Zaheer IqbalTechnical Assurance & ImplementationCommented:
0
Cloud Class® Course: Certified Penetration Testing

This CPTE Certified Penetration Testing Engineer course covers everything you need to know about becoming a Certified Penetration Testing Engineer. Career Path: Professional roles include Ethical Hackers, Security Consultants, System Administrators, and Chief Security Officers.

Vikash MohanTechnical DirectorAuthor Commented:
Thanks for the reply, I will try both of your solutions, but will they effect users whilst they are currently working?
0
x-menIT super heroCommented:
WSUS is a repository for windows updates, it does not affect users working.
0
Vikash MohanTechnical DirectorAuthor Commented:
Currently running x-men application he offered, i shall let you know the results.
0
Thomas GrassiSystems AdministratorCommented:
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
0
DonNetwork AdministratorCommented:
0

Experts Exchange Solution brought to you by

Your issues matter to us.

Facing a tech roadblock? Get the help and guidance you need from experienced professionals who care. Ask your question anytime, anywhere, with no hassle.

Start your 7-day free trial
DonNetwork AdministratorCommented:
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.
0
Gary ColtharpSr. Systems EngineerCommented:
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
0
Vikash MohanTechnical DirectorAuthor Commented:
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.
0
Vikash MohanTechnical DirectorAuthor Commented:
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!
0
It's more than this solution.Get answers and train to solve all your tech problems - anytime, anywhere.Try it for free Edge Out The Competitionfor your dream job with proven skills and certifications.Get started today Stand Outas the employee with proven skills.Start learning today for free Move Your Career Forwardwith certification training in the latest technologies.Start your trial today
SBS

From novice to tech pro — start learning today.