Re: WSUS 2.0 grew to 16 GB - need to fix

It seems that the log file is growing (.ldf file) and that means that something could have changed the recovery model of the database (which implies that the log is not truncating due to lack of backups).

Try following the instructions on the link http://support.microsoft.com/kb/873235/en-us to change the recovery model.

My advise would be to try to upgrade to version 3.0 SP1 which has a much easier interface to work.

--
Costas
http://costas.cpstechgroup.com




"Steven Helms" <steve@xxxxxxxxxx> wrote in message news:u2Dzdml7IHA.5024@xxxxxxxxxxxxxxxxxxxxxxx
susdb.mdf is 4,102,976 KB
templog.ldf is 7,915,712 KB

"Costas" <cpstechgroup@xxxxxxxxx> wrote in message news:O1uWAel7IHA.1468@xxxxxxxxxxxxxxxxxxxxxxx
Steve,

Does the data file with 16GB size has the extension .mdf or is it .ldf?

--
Costas
http://costas.cpstechgroup.com




"Steven Helms" <steve@xxxxxxxxxx> wrote in message news:O$Bp5#k7IHA.5164@xxxxxxxxxxxxxxxxxxxxxxx
Something has happened to WSUS 2.0 on SBS 2003 R2 Standard after running fine for over a year.
The database has grown to over 16 GB and consumed all drive space.
How can this be fixed and disk space be regained?

Thank you,
Steve



.

Relevant Pages

  • Re: Simple recovery model + checkpoint = no need to save .ldf file?
    ... The files can also be moved to another server and ... writes all changes to the data files before the database is detached. ... you do not need the log file as sp_attach_single_file_db can be used ... > If I have a sql server 2000 database using the simple recovery model and ...
    (microsoft.public.sqlserver.server)
  • Re: Will this shrinkfile method work?
    ... There is no need to change the recovery model at all. ... If the active VLF is near the end of the log file it may take a little ... while for it to shrink but it will. ... Right click the database, choose TASKS - SHRINK - DATABASE ...
    (microsoft.public.sqlserver.setup)
  • Re: Log file growing very large??
    ... > BULK_LOGGED.Please change the recovery model for the database to ... You could truncate the transaction ... > Now execute the below command to see log file size and usage. ...
    (microsoft.public.sqlserver.msde)
  • Re: Please evaluate this approach to shrinking log files
    ... A common cause of unruly log files is that the database is in the FULL ... recovery model but regular transaction log backups are not scheduled. ... IMHO, log file ...
    (comp.databases.ms-sqlserver)
  • Recover db from .mdf and .ldf files in sql server7.0
    ... but not your log file as it ... Backup file of master database exists. ... How to get the information in the .ldf file? ...
    (microsoft.public.sqlserver.server)