Check out your developers, especially Joe "Cartisian". . . . .



>>> "Sam Rieta "
<mssqldba-ezmlmshield-x73425941.[Email address protected] 6/29/2006
11:27:32 AM >>>

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



---------------------------------------------------------------------
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