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
Solved

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

Posted on 2012-12-24
10
6,425 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
Networking for the Cloud Era

Join Microsoft and Riverbed for a discussion and demonstration of enhancements to SteelConnect:
-One-click orchestration and cloud connectivity in Azure environments
-Tight integration of SD-WAN and WAN optimization capabilities
-Scalability and resiliency equal to a data center

 
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

Free Tool: Path Explorer

An intuitive utility to help find the CSS path to UI elements on a webpage. These paths are used frequently in a variety of front-end development and QA automation tasks.

One of a set of tools we're offering as a way of saying thank you for being a part of the community.

Question has a verified solution.

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

I work for a company that primarily works with small businesses as their outsourced IT vendor. As such the majority of these customers utilize some version of Small Business Server. Due to the economics of running a small business, many of these cus…
If you are a user of the discontinued Microsoft Office Accounting 2008 (MSOA) and have to move to a new computer running Windows 8, you will be unhappy to discover that it won't install.  In particular, Microsoft SQL Server 2005 Express Edition (SSE…
With Secure Portal Encryption, the recipient is sent a link to their email address directing them to the email laundry delivery page. From there, the recipient will be required to enter a user name and password to enter the page. Once the recipient …
I've attached the XLSM Excel spreadsheet I used in the video and also text files containing the macros used below. https://filedb.experts-exchange.com/incoming/2017/03_w12/1151775/Permutations.txt https://filedb.experts-exchange.com/incoming/201…

839 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