Still celebrating National IT Professionals Day with 3 months of free Premium Membership. Use Code ITDAY17

x
?
Solved

How big should susdb.mdf be on Small Business Server 2008 ?

Posted on 2012-12-24
10
Medium Priority
?
6,594 Views
Last Modified: 2013-01-13
Hi,
The susdb.mdf file on my Small Business Server 2008 has grown to be 9Gb.  What size should it be ?  
Regards
Michael
0
Comment
Question by:Michael Green
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
  • 4
  • 3
  • 2
  • +1
10 Comments
 
LVL 18

Assisted Solution

by:Sushil Sonawane
Sushil Sonawane earned 1500 total points
ID: 38718333
Susdb.mdf file size 9 GB is not an issue. If you want to reduce the size then you have following  option.

1) Srink the database :

http://technet.microsoft.com/en-us/library/ms190757.aspx

http://social.msdn.microsoft.com/Forums/en/sqlgetstarted/thread/c186ac0f-929f-4724-b9d7-fd514b76a542


2) Move WSUS Content and Database Files to a Different Volume

Refer link:
http://blogs.technet.com/b/sbs/archive/2009/09/23/how-to-move-wsus-content-and-database-files-to-a-different-partition.aspx

3) Use Wsus cleanup wizard.

Refer below link:
http://technet.microsoft.com/en-us/library/dd939856(v=ws.10).aspx
0
 
LVL 76

Expert Comment

by:Alan Hardisty
ID: 38718334
I have a server that has a 10.9Gb susdb.mdf file, so 9Gb isn't unusual.  Another I look after is only 5.8Gb.

Alan
0
 

Author Comment

by:Michael Green
ID: 38718338
I've already tried shrinking the database - did nothing.

I'm now running the Update Services 'Server Clean-up Wizard'....but has been running the whole day so far.....
0
Technology Partners: We Want Your Opinion!

We value your feedback.

Take our survey and automatically be enter to win anyone of the following:
Yeti Cooler, Amazon eGift Card, and Movie eGift Card!

 
LVL 76

Expert Comment

by:Alan Hardisty
ID: 38718347
It's not the fastest and probably won't free up that much space.

Are you running low on space and trying to reclaim it?

If you are, please have a read of my blog:

http://alanhardisty.wordpress.com/2012/07/12/sbs-2008-2011-disk-space-eaten-up-by-sharepoint-sql-log-files-how-to-reduce-the-log-file-size/

There are various links to sites advising how to reduce the wasted space on an SBS 2008 / SBS 2011 server that should help if you are looking to free up space.  The biggest hog will probably be the Sharepoint SQL Log file.
0
 
LVL 22

Expert Comment

by:Larry Struckmeyer MVP
ID: 38719536
When running the clean up wizard for the first time, do one step at a time.  Then look at downloading and scheduling this:

http://wsus.codeplex.com/releases/view/17612
0
 

Author Comment

by:Michael Green
ID: 38753757
The clean-up wizard took over 24 hours to run all steps.

alanardisty - no - the biggest space hog is NOT the Sharepoint log file.  
fl_flyfishing - thanks for the tip running it one step at a time.  Unfortunately I'd already started running all of it.  Also after running it the SUSDB.MDF is not any smaller.

Any other ideas on how I can reduce the size of SUSDB.MDF (without moving it to a new drive) ?
0
 
LVL 76

Expert Comment

by:Alan Hardisty
ID: 38753775
It will grow to be the size it needs for your environment and the patches / updates required for your computers.  It isn't something I would be looking to reduce / or being able to reduce significantly.

If you need the space I would be moving the database elsewhere.
0
 

Accepted Solution

by:
Michael Green earned 0 total points
ID: 38753798
After running the clean-up wizard I decided to try to shrink the database again - and it came down to 3.4 Gb i.e. less than half.

So I think sushil84 had the right list - just perhaps in the wrong order.

I think the options to reduce size are (in order):
1. Run the WSUS Clean-up wizard
2. Shrink the WSUSDB database
3. Move the database to another drive (if you still need more space).

Is there anything else that should be added to this list e.g. for long term maintenance ?
0
 
LVL 18

Expert Comment

by:Sushil Sonawane
ID: 38755876
In Wsus console toolbar select products which u want, Please don't select unwanted product. It's increase the database size and utilize more internet bandwidth.
0
 

Author Closing Comment

by:Michael Green
ID: 38771634
Solutions required testing and being put in the correct order.
0

Featured Post

Independent Software Vendors: We Want Your Opinion

We value your feedback.

Take our survey and automatically be enter to win anyone of the following:
Yeti Cooler, Amazon eGift Card, and Movie eGift Card!

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

The SBS 2011 release date (RTM) is supposed to be around Christmas, 2011.  This article is a compilation of my notes -- things I have learned first hand.  The items are in a rather random order, but I think this list covers most of what is new and d…
A quick step-by-step overview of installing and configuring Carbonite Server Backup.
This tutorial will teach you the special effect of super speed similar to the fictional character Wally West aka "The Flash" After Shake : http://www.videocopilot.net/presets/after_shake/ All lightning effects with instructions : http://www.mediaf…
In this video, Percona Director of Solution Engineering Jon Tobin discusses the function and features of Percona Server for MongoDB. How Percona can help Percona can help you determine if Percona Server for MongoDB is the right solution for …

715 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question