[Webinar] Streamline your web hosting managementRegister Today

x
  • Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 6677
  • Last Modified:

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

Hi,
The susdb.mdf file on my Small Business Server 2008 has grown to be 9Gb.  What size should it be ?  
Regards
Michael
0
Michael Green
Asked:
Michael Green
  • 4
  • 3
  • 2
  • +1
2 Solutions
 
Sushil SonawaneCommented:
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
 
Alan HardistyCo-OwnerCommented:
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
 
Michael GreenSenior IT Consultant / IT Project ManagerAuthor Commented:
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
[Webinar] Kill tickets & tabs using PowerShell

Are you tired of cycling through the same browser tabs everyday to close the same repetitive tickets? In this webinar JumpCloud will show how you can leverage RESTful APIs to build your own PowerShell modules to kill tickets & tabs using the PowerShell command Invoke-RestMethod.

 
Alan HardistyCo-OwnerCommented:
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
 
Larry Struckmeyer MVPCommented:
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
 
Michael GreenSenior IT Consultant / IT Project ManagerAuthor Commented:
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
 
Alan HardistyCo-OwnerCommented:
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
 
Michael GreenSenior IT Consultant / IT Project ManagerAuthor Commented:
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
 
Sushil SonawaneCommented:
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
 
Michael GreenSenior IT Consultant / IT Project ManagerAuthor Commented:
Solutions required testing and being put in the correct order.
0

Featured Post

Free Tool: SSL Checker

Scans your site and returns information about your SSL implementation and certificate. Helpful for debugging and validating your SSL configuration.

One of a set of tools we are providing to everyone as a way of saying thank you for being a part of the community.

  • 4
  • 3
  • 2
  • +1
Tackle projects and never again get stuck behind a technical roadblock.
Join Now