If those are legit transactions, and not the result of a set based operation
wrapped in a large transaction, then more frequent backups could potentially
make the log files smaller. I agree, use Profiler or any other means to
determine what is causing the bloat. In my experience, it can be the result
of a Cartesian product on an insert statement (who would write this! Uggh
:p), the result of a large batch operation or something similar. Large batch
operations = bigger log files usually, at least my experience they do.
Hope this helps.
Bob
-----Original Message-----
From: Sam Rieta
[mailto:mssqldba-ezmlmshield-x73425941.[Email address protected]
Sent: Thursday, June 29, 2006 11:28 AM
To: LazyDBA Discussion
Subject: RE: Want to shrink !!!
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