wsus templog.ldf size growing and growing

Discussion in 'Windows Small Business Server' started by Joe#2, Jun 9, 2009.

  1. Joe#2

    Joe#2 Guest

    One of my SBS2003R2 premiun installs has the ongoing problem of the WSUS
    templog.ldf file growing until it fills the disk.

    I know that just stopping then restarting the service shrinks it down. I
    also know the fix is setting the MSSQL/WSUS backup to simple is the fix.
    However I can not find the place to set it to simple! When I open MSSQL 2005
    I can not fine the WSUS service listed.

    I have searched all over but have not yet found the answere to the "how to".

    My SQL experience is limited, would someone please point me in the right
    direction?
     
    Joe#2, Jun 9, 2009
    #1
    1. Advertisements

  2. Joe#2

    Joe#2 Guest

    Hum, I don't know how to be more specific.

    It is the templog.ldf file created by WSUS. It will apparently grow forever.
    the short-term solution is to restart the MSSQL wsus service. The longterm
    fix acording to all I have read is to set the backup recovery model from full
    to simple on the WSUS data base in SQL. The only trouble is I cant find the
    WSUS database in SQL2005. I can find noplace on the server that I can make
    this change.
     
    Joe#2, Jun 9, 2009
    #2
    1. Advertisements

  3. Joe#2

    Duncan McC Guest

    Mate, you've been given the info...

    In SQL Server management console, open the WSUS database - put this in
    to do it (quoting below here, I hope Russ spelt it out correctly :) ...

    \\.\pipe\mssql$microsoft##ssee\sql\query

    yep, he did :)

    *That* opens the WSUS database.

    I think you can now find the rest :)

    .... drill into Databases, right click SUSDB and select Properties, click
    Options (I bet the Recovery Model is already set to Simple).
     
    Duncan McC, Jun 9, 2009
    #3
    1. Advertisements

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments (here). After that, you can post your question and our members will help you out.