Solved

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

Posted on 2012-12-24
10
6,446 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
  • 4
  • 3
  • 2
  • +1
10 Comments
 
LVL 18

Assisted Solution

by:Sushil Sonawane
Sushil Sonawane earned 500 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

Industry Leaders: 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

This guide is intended to provide step by step instructions on how to migrate from Small Business Server 2003 to Small Business Server 2011. NOTE: This guide has been written using the preview version of SBS2011 therefore some of the screens may …
I've often see, or have been asked, the question about the difference between the Exchange 2010 SP1 version, available as part of Small Business Server (SBS) 2011, and the “normal” Exchange 2010 SP1 Standard. The answer to the question is relativ…
Nobody understands Phishing better than an anti-spam company. That’s why we are providing Phishing Awareness Training to our customers. According to a report by Verizon, only 3% of targeted users report malicious emails to management. With compan…
Attackers love to prey on accounts that have privileges. Reducing privileged accounts and protecting privileged accounts therefore is paramount. Users, groups, and service accounts need to be protected to help protect the entire Active Directory …

749 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