Increasing the frequency of the log backups isn't going to decrease his
log size. You're on the right path though Carolyn.
Find out what is causing the Log file balloon up like that. Fix that if
you can, than adjust the log/transaction backup frequency.


-----Original Message-----
From: Carolyn Jewel
[mailto:mssqldba-ezmlmshield-x11796014.[Email address protected]
Sent: Thursday, June 29, 2006 11:17 AM
To: LazyDBA Discussion
Subject: RE: Want to shrink !!!

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.


---------------------------------------------------------------------
TO REPLY TO EVERBODY , PLEASE CLICK REPLY-ALL, NOT JUST REPLY
Website : http://www.LazyDBA.com
To unsubscribe: http://www.lazydba.com/unsubscribe.html


MS Sql Server LazyDBA home page