August 4, 2010 at 2:36 am
Hi All,
I restricted the log file size of one of the database to 10GB.Every week the log file is growing up to 10GB and i am getting alerts.then i am shrinking the log file every time.I dont know why the log file is growing continuosly and hugely.I want to do permanent fix for it. can any one please let me know the permanent fix for this issue?
Thanks in advance,
Vamshi Madineni.
August 4, 2010 at 2:43 am
DB recovery model is FULL?
I Have Nine Lives You Have One Only
THINK!
August 4, 2010 at 2:45 am
This was removed by the editor as SPAM
August 4, 2010 at 2:47 am
You should create a maintenance plan to take log backup regularly.
If log backup is not taken, log entries remain in the file and file grows continuously.
Hope this helps you.
August 4, 2010 at 2:51 am
vamshi.sql (8/4/2010)
Yes.DB Recovery model is Full.Even Auto Srink option is also enabled.the database is in Sql Server 2000.
Disable Auto Shrink.
August 4, 2010 at 2:57 am
This was removed by the editor as SPAM
August 4, 2010 at 3:00 am
Yes.DB Recovery model is Full, Sql Server 2000
in this case you have to make backup db and after backup log wtih TRUNCATE_ONLY options
I Have Nine Lives You Have One Only
THINK!
August 4, 2010 at 3:07 am
vamshi.sql (8/4/2010)
that is ok.i enabled auto shrink option,but why that is not happening once the log file is grown extremely..please let me know...
Is log backup happening regularly?
AutoShrink does not remove the log entries from the file. Auto Shrink can shrink the file only if there is unused space in the file.
You should take log backup regularly to clear the log entries from the file and make room for new log entries.
Viewing 8 posts - 1 through 8 (of 8 total)
You must be logged in to reply to this topic. Login to reply