wsus templog.ldf size growing and growing

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?

Are you talking about the memory usage?
If so put in \\.\pipe\mssql$microsoft##ssee\sql\query

If it's the Database Move try this link
http://www.netmavens.net/HowTo/WSUS/MoveWSUSMSDE.htm

If something else please be more specific
Thanks
Russ

--
Russell Grover - SBITS.Biz
Microsoft Gold Certified Partner
Microsoft Certified Small Business Specialist
World Wide 24hr SBS Remote Support - http://www.SBSrepair.com
Microsoft Online Services - http://www.microsoft-online-services.com/



"Joe#2" <Joe2@discussions.microsoft.com> wrote in message
news:B6AEAE26-2356-466C-A70A-BCCF30872DF4@microsoft.com...
> 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?

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.

"Russ - www.SBITS.Biz" wrote:

> Are you talking about the memory usage?
> If so put in \\.\pipe\mssql$microsoft##ssee\sql\query
>
> If it's the Database Move try this link
> http://www.netmavens.net/HowTo/WSUS/MoveWSUSMSDE.htm
>
> If something else please be more specific
> Thanks
> Russ
>
> --
> Russell Grover - SBITS.Biz
> Microsoft Gold Certified Partner
> Microsoft Certified Small Business Specialist
> World Wide 24hr SBS Remote Support - http://www.SBSrepair.com
> Microsoft Online Services - http://www.microsoft-online-services.com/
>
>
>
> "Joe#2" <Joe2@discussions.microsoft.com> wrote in message
> news:B6AEAE26-2356-466C-A70A-BCCF30872DF4@microsoft.com...
> > 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?
>

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

In article <E7F2C647-745E-4CC6-A341-DCD65C34C363@microsoft.com>, Joe2
@discussions.microsoft.com says...
> 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.
>
> "Russ - www.SBITS.Biz" wrote:
>
> > Are you talking about the memory usage?
> > If so put in \\.\pipe\mssql$microsoft##ssee\sql\query
> >
> > If it's the Database Move try this link
> > http://www.netmavens.net/HowTo/WSUS/MoveWSUSMSDE.htm
> >
> > If something else please be more specific
> > Thanks
> > Russ
> >
> > --
> > Russell Grover - SBITS.Biz
> > Microsoft Gold Certified Partner
> > Microsoft Certified Small Business Specialist
> > World Wide 24hr SBS Remote Support - http://www.SBSrepair.com
> > Microsoft Online Services - http://www.microsoft-online-services.com/
> >
> >
> >
> > "Joe#2" <Joe2@discussions.microsoft.com> wrote in message
> > news:B6AEAE26-2356-466C-A70A-BCCF30872DF4@microsoft.com...
> > > 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?
> >
>