[Product update] Infrastructure Analysis Tool is now available with Business Accounts.Learn More
Experts Exchange Solution brought to you by
"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.
The most successful MSPs rely on metrics – known as key performance indicators (KPIs) – for making informed decisions that help their businesses thrive, rather than just survive. This eBook provides an overview of the most important KPIs used by top MSPs.
Facing a tech roadblock? Get the help and guidance you need from experienced professionals who care. Ask your question anytime, anywhere, with no hassle.
The cleanup wizard (at least for WSUS 3.0 where I tried) doesn't shrink the DB at all. The space may be free and be reused after but the db flies aren't shrinked (which actually makes sense as SQL Server else has to make it larger again later). First step sure is to run the wizard to get rid of obsolete updates filling the database and file system.
If you after this run still have real need on wasted storage you can do following:
- Ensure Windows Internal Database Service is started
- Start the Management Studio of SQL Server 2008 R2. Important: You have to start it with "Run as Administrator", else you won't get the required permissions.
- Link to the Windows Internal Database server using the pipe as server address:
- Now you should be connected to the WSUS3 Database server and see in the Branch Databases the Database SUSDB.
- Rightclick on it and select the Task to shrink either the database or the files what ever you prefer.
BTW: For me this reduced the size of the database files (data and log file) from 8.5GBytes to 3.5GBytes.
Now the database should be shrunk to a reasonable size and the unrequired space should have been freed up on the disk.
But again - WSUS will have to expand the database file when running and the database may grow to the seen size quickly again.
From novice to tech pro — start learning today.
Premium members can enroll in this course at no extra cost.