WSUS Keeps crashing – SBS 2008/Standard FE

Home Forums Server Operating Systems SBS 2000 / 2003 / 2008 / 2011 WSUS Keeps crashing – SBS 2008/Standard FE

This topic contains 11 replies, has 6 voices, and was last updated by Avatar EarthReactor 5 years, 4 months ago.

Viewing 12 posts - 1 through 12 (of 12 total)
  • Author
    Posts
  • Avatar
    davids355
    Member
    #164530

    I have a system running Server standard FE.
    Its actually part of a terminal server solution so there are only two computers in the network – that one, and a terminal server running server 2008 standard.

    There is a problem in that the C drive is running out of space, and upon investigation I have found that the WSUS folder is around 28GB in size, which is about 10% of the total drive size.

    Looking into it further, I found that the SUSDB database file itself is 26GB in size.

    I have been trying to research ways in which to lower the size of this file, but the only options I could find are running the cleanup wizard in WSUS console, and then running the shrink database option in SQL.

    The problem is every time I run the cleanup wizard, it runs for several hours, then crashes WSUS console – I get a prompt to reset the node, then I can run the cleanup again, after doing this a few times, it crashes and I can no longer connect to WSUS console without a reboot of the entire server.

    When I look in SQL management studio and select teh shrink DB option, it says there is only around 1GB free space that it can be shrunk by, which would leave it at 25GB.

    Is there any other way to shrink the size of this database?

    Avatar
    biggles77
    Spectator
    #213427

    Re: WSUS Keeps crashing – SBS 2008/Standard FE

    David, do you have the option of moving WSUS to a different partition or HDD? Also, 28GB sounds very small for WSUS updates.

    Avatar
    EarthReactor
    Member
    #377240

    Re: WSUS Keeps crashing – SBS 2008/Standard FE

    biggles77;287960 wrote:
    David, do you have the option of moving WSUS to a different partition or HDD? Also, 28GB sounds very small for WSUS updates.

    28GB is not the updates themselves – I have already changed the settings so that updates are not stored locally, its just the DB file size, is that still small?

    The option to move the database, if the above is normal then yes it will be an option, the only issue is that the systems are on managed hosting so space comes at a premium. For that reason I just wanted to explore other options first.

    Avatar
    biggles77
    Spectator
    #213428

    Re: WSUS Keeps crashing – SBS 2008/Standard FE

    Can’t remember the DB size of the last WSUS that I setup but the Contents were 160GB. I also NEVER put an WSUS onto a C partition due to its tendency to over indulge itself (like me and Hokey Pokey ice cream :mrgreen: ).

    I thought THIS was interesting and might be worth a look. It may help reduce you DB size.

    Don’t know what you are using for the DB but I will guess it is the Internal option. If it is then the following link may be of interest.
    WSUS 3.0 : Connecting, Managing and Moving SUSDB as Internal Database

    At THIS link have a look at What to Check, the 3rd paragraph, Download Files Only When Updates are Approved and see if that helps.

    HowTo: WSUS Cleanup – Shrink a WSUS database (susdb) to almost zero

    [The faster we respond David, the more we get paid] [ATTACH]6167[/ATTACH]

    Avatar
    Ossian
    Moderator
    #190061

    Re: WSUS Keeps crashing – SBS 2008/Standard FE

    Have you run the Move WSUS wizard (since you are using SBS)?
    What about the WSUS cleanup then a db Shrink?

    Avatar
    EarthReactor
    Member
    #377241

    Re: WSUS Keeps crashing – SBS 2008/Standard FE

    Biggles77

    Thanks for the info, ok by the sounds of it my situation isn’t abnormal then, although it is strange that the WSUS console continuously crashes and becomes unresponsive.

    Ossian

    I have tried the cleanup but it continuously crashes out.
    I have not tried the Move WSUS wizard yet mainly because I dont have anywhere to move it to.

    Having said that, based on everyones comments, I think that is the sensible option, so I will arrange for some addtional storage, and then move WSUS to it.

    Ill report back with result.
    Thanks guys.

    Avatar
    cruachan
    Participant
    #330729

    Re: WSUS Keeps crashing – SBS 2008/Standard FE

    davids355;287976 wrote:
    Thanks for the info, ok by the sounds of it my situation isn’t abnormal then, although it is strange that the WSUS console continuously crashes and becomes unresponsive.

    Far from abnormal, it’s almost expected behavior in WSUS running under SBS IME. :shock:

    From what you said though, you’ve changed the default WSUS settings so it doesn’t keep the updates locally. IIRC that might be the issue, or at least part of it, as SBS throws it’s toys out of the pram if WSUS isn’t exactly as it likes. Might be worth running the SBS BPA and seeing what it says.

    Avatar
    EarthReactor
    Member
    #377242

    Re: WSUS Keeps crashing – SBS 2008/Standard FE

    cruachan;287977 wrote:
    Far from abnormal, it’s almost expected behavior in WSUS running under SBS IME. :shock:

    From what you said though, you’ve changed the default WSUS settings so it doesn’t keep the updates locally. IIRC that might be the issue, or at least part of it, as SBS throws it’s toys out of the pram if WSUS isn’t exactly as it likes. Might be worth running the SBS BPA and seeing what it says.

    Thats a fair point.
    I am trying the cleanup tool now, but only ticking one box at a time, maybe that will work, if not then Ill go for getting an additional drive and moving the DB over to that.

    Avatar
    biggles77
    Spectator
    #213429

    Re: WSUS Keeps crashing – SBS 2008/Standard FE

    If you manage to shrink the DB down, I would be interested in how small it gets.

    Thanks David.

    Avatar
    EarthReactor
    Member
    #377243

    Re: WSUS Keeps crashing – SBS 2008/Standard FE

    I’ll post back here when I have an update.

    Avatar
    teiger
    Member
    #231162

    Re: WSUS Keeps crashing – SBS 2008/Standard FE

    Tip: if you have never successfully run the WSUS cleanup wizard before, as you say it may run for hours. So uncheck all the options to cleanup then re-check only one. If that runs successfully, repeat for the next item, one at a time. Wash and repeat!

    Avatar
    Ossian
    Moderator
    #190066

    Re: WSUS Keeps crashing – SBS 2008/Standard FE

    Also (not just on SBS) WSUS may error on you “connection failed” or similar so keep running the cleanup until it finally completes.

    Reindexing the database (see http://gallery.technet.microsoft.com/ScriptCenter/6f8cde49-5c52-4abd-9820-f1d270ddea61/) may help

Viewing 12 posts - 1 through 12 (of 12 total)

You must be logged in to reply to this topic.