How often are you backing up the Transaction log? Try increasing the
frequency of your log backups.

Carolyn J


-----Original Message-----
From: Reed William L.
[mailto:mssqldba-ezmlmshield-x6810259.[Email address protected]
Sent: Thursday, June 29, 2006 11:02 AM
To: LazyDBA Discussion
Subject: RE: Want to shrink !!!

I've been working with a SQL 2005 DB that is being used by WebRoot. The
primary file is 200 MB. The log file on the other hand is getting huge!

16GB!!

The recovery model is set to Full and the Maint Plan runs every morning
at 1AM and does a Full Backup.

The log file seems to be out of control.

Any advice would be very helpful.

MS Sql Server LazyDBA home page