When using the BACKUP DATABASE, does it backup the log file too? Or do
I need to run a BACKUP LOG in addition?
Bill
-----Original Message-----
From: Mordechai Danielov
[mailto:mssqldba-ezmlmshield-x68095336.[Email address protected]
Sent: Thursday, June 29, 2006 2:52 PM
To: LazyDBA Discussion
Subject: RE: Want to shrink !!!
Look at the server first to see if you are backing up the transaction
log.
If you are not, you'll save yourself a lot of trouble by looking there
first.
-----Original Message-----
From: Reed William L.
[mailto:mssqldba-ezmlmshield-x16073533.[Email address protected]
Sent: Thursday, June 29, 2006 2:46 PM
To: LazyDBA Discussion
Subject: RE: Want to shrink !!!
Great idea. Thanks! I've searching WebRoot's KB and so far I've found
nothing. You're right, it's time to run a trace to find out what's
happening.
Thanks again,
Bill
-----Original Message-----
From: Bob
[mailto:mssqldba-ezmlmshield-x64308978.[Email address protected]
Sent: Thursday, June 29, 2006 2:42 PM
To: LazyDBA Discussion
Subject: RE: Want to shrink !!!
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
---------------------------------------------------------------------
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
---------------------------------------------------------------------
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