Solved

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

Posted on 2012-12-24
10
6,361 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
 
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 21

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
Network it in WD Red

There's an industry-leading WD Red drive for every compatible NAS system to help fulfill your data storage needs. With drives up to 8TB, WD Red offers a wide array of solutions for customers looking to build the biggest, best-performing NAS storage solution.  

 

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

Is Your Active Directory as Secure as You Think?

More than 75% of all records are compromised because of the loss or theft of a privileged credential. Experts have been exploring Active Directory infrastructure to identify key threats and establish best practices for keeping data safe. Attend this month’s webinar to learn more.

Question has a verified solution.

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

Suggested Solutions

A lot of problems and solutions are available on the net for the error message "Source server does not meet minimum requirements for migration" while performing a migration from Small Business Server 2003 to SBS 2008. This error pops up just before …
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…
I designed this idea while studying technology in the classroom.  This is a semester long project.  Students are asked to take photographs on a specific topic which they find meaningful, it can be a place or situation such as travel or homelessness.…
A company’s greatest vulnerability is their email. CEO fraud, ransomware and spear phishing attacks are the no1 threat to a company’s security. Cybercrime is responsible for the largest loss of money to companies today with losses projected to r…

914 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

Need Help in Real-Time?

Connect with top rated Experts

17 Experts available now in Live!

Get 1:1 Help Now