none
Susdb.mdf file too big on a Windows SBS 2008 server

    Question

  • I One of my customers is running Windows 2008 Small Business Server. Windows Update Contant folders had been correctly moved away from C drive soon after installation of the server (WSUS Content). That folder is about 8 GB big (small network, 8 computers). The susdb.mdf file however, is still on the C drive and is a whopping 15.1 GB big. I believe this is not according to plan. I have done some server cleanup through the specific WSUS interface, but the biggest chunk just hangs. What can I do? None of the suggestions I found have worked.

    Kind regards,

    Wouter Pinkhof


    Wouter Pinkhof PINKH bvba, PC-Hulp.com

    Thursday, December 20, 2012 5:35 PM

Answers

All replies

  • Hi,

    How to Move WSUS Content and Database Files to a Different Volume for Windows Server Essentials and Small Business Server:http://blogs.technet.com/b/sbs/archive/2009/09/23/how-to-move-wsus-content-and-database-files-to-a-different-partition.aspx


    regards,

    Clarence


    Please remember to click “Mark as Answer” on the post that helps you, and to click “Unmark as Answer” if a marked post does not actually answer your question. This can be beneficial to other community members reading the thread.

    Monday, December 24, 2012 3:16 AM
    Moderator
  • The susdb.mdf file however, is still on the C drive and is a whopping 15.1 GB big.

    I do find it somewhat incredulous that a SUSDB.mdf file on a Small Business Server could grow to 15GB+ in size.

    I cannot imagine any scenario in which the 30,000+ updates synchronized by a default SBS2008 server, in combination with the default groups, and auto-approvals, and the maximum 75 clients with the default WUAgent policies, could produce a 15GB database. The idea that =8= clients could do this is near impossible. (In fact, I can't recall that I have ever seen a 15GB SUSDB.mdf!)

    It is possible that an SBS2008 Premium Edition server with WSUS installed to the SQL Server Workgroup Edition instance (not the Windows Internal Database) could produce a 15GB+ SUSDB.LDF (transaction log) file, if the WSUS database were inadvertently created as a Full Recovery database.

    In any event, as is the natural behavior of SQL Server, merely running the Server Cleanup Wizard is not going to shrink the file size. In fact, merely running the Server Cleanup Wizard on an SBS2008 server isn't going to do much of anything useful without first removing the thousands of legacy approvals that were likely generated from the automatic approval rules enabled by default. Assuming those thousands of approvals were removed, and the updates actually declined, the SCW might remove a few hundred rows from the database, but that's still not going to shrink a 15GB+ MDF file. Finding out why there's a 15GB+ MDF file really is the first step to identifying an appropriate solution.


    Lawrence Garvin, M.S., MCITP:EA, MCDBA, MCSA
    SolarWinds Head Geek
    Microsoft MVP - Software Distribution (2005-2012)
    My MVP Profile: http://mvp.support.microsoft.com/profile/Lawrence.Garvin
    The views expressed on this post are mine and do not necessarily reflect the views of SolarWinds.

    Friday, December 28, 2012 3:01 AM
    Moderator
  • Mine is 13.9GB, small network, 10 people. Simply incredulous...

    Tuesday, April 30, 2013 11:03 PM
  • 11GB here. And we don't even use it...
    Thursday, May 02, 2013 9:36 AM
  • I hve this same issue, running out of room on C drive with a SBS 2008 server and I have moved all data from the C drive that you can move with the SBS consel to another drive and yet this SUSDB file on the c:\wsus\susdb\updateservicesdbfile\ is 13 gigs I would like to reclaim some of that because email has stopped because there is only 600 megs free on the server.

    how can this DB be reduced or moved?


    Brandon Dillon

    Wednesday, May 22, 2013 12:05 AM
  • how can this DB be reduced or moved?

    First we have to figure out why it's so large; luckily on an SBS system we have a couple of readily available known conditions.

    1. Decline any unneeded updates -- this likely will include several thousand Definition Updates. "Unneeded" is defined as any update reported as "100% Installed/NotApplicable" and superseded.
    2. Run the Server Cleanup Wizard to delete expired updates and old revisions. (This may take multiple runs if the SCW times out performing the task, just restart the SCW and let it run some more)
    3. Run the Server Cleanup Wizard a 2nd time to delete files freed up by the thousands of updates that were declined in Step #1.
    4. Verify that the Client Detection Frequency is in a reasonable range. (Anything less than six hours is pointless.)
    5. Manually delete any computers in All Computers that are not operational. (The Server Cleanup Wizard can do this for machines out-of-service more than 30 days, but in an SBS environment where you probably know every client system by sight, it might be better to visually verify what's there and what ought not be.)
    6. Using SQL Server Management Studio, inspect the actual amount of data storage consumed by the data, and compare that to the physical side of the MDF file. If the actual data consumption is less than 80% of the physical database file size, you may get some benefit from shrinking the database file. If there's <20% free space, though, it's not worth the effort.
    7. After shrinking the database, if applicable, stop the SQL Server service hosting the WSUS database and defragment the filesystem hosting the WSUS database.
    8. Restart the SQL Server service and run the WSUS DB Maintenance utility to reindex the database and recalculate table statistics.


    Lawrence Garvin, M.S., MCITP:EA, MCDBA, MCSA
    SolarWinds Head Geek
    Microsoft MVP - Software Packaging, Deployment & Servicing (2005-2013)
    My MVP Profile: http://mvp.support.microsoft.com/profile/Lawrence.Garvin
    http://www.solarwinds.com/gotmicrosoft
    The views expressed on this post are mine and do not necessarily reflect the views of SolarWinds.

    Thursday, May 30, 2013 12:03 AM
    Moderator