Message from discussion
Log file size growing rapidly.. increased by 1 GB every week
From: "Uri Dimant" <u...@iscar.co.il>
References: <uWnh13jZIHA.4712@TK2MSFTNGP05.phx.gbl>
Subject: Re: Log file size growing rapidly.. increased by 1 GB every week
Date: Sun, 3 Feb 2008 10:54:26 +0200
Lines: 36
X-Priority: 3
X-MSMail-Priority: Normal
X-Newsreader: Microsoft Outlook Express 6.00.2900.3138
X-MimeOLE: Produced By Microsoft MimeOLE V6.00.2900.3198
X-RFC2646: Format=Flowed; Response
Message-ID: <eVZW1IkZIHA.4332@TK2MSFTNGP04.phx.gbl>
Newsgroups: microsoft.public.sqlserver.server
NNTP-Posting-Host: gw.iscar.com 212.25.106.78
Path: g2news1.google.com!news2.google.com!newshub.sdsu.edu!TK2MSFTNGP01.phx.gbl!TK2MSFTNGP04.phx.gbl
Venkat
What is recovery model of your db? Its possible it has FULL recovery mode.
If so, please start performing BACKUP LOG to move an inactive transactions
to be moved on the disk. I'd suggest you read about recovery models in the
BOL to understand their impact on the database....
"Venkat" <venkatara...@gmail.com> wrote in message
news:uWnh13jZIHA.4712@TK2MSFTNGP05.phx.gbl...
> Hi,
> My sql server database log file size growing rapidly, 1 GB by every week.
> I have a service running every 2 hours which deletes and inserts some
> data, say around 5000 records for every two hours.
>
> I know the source of the problem is deleting and inserting records for
> every 2 hours. I want to go for a densive mechansim for this, that is: i
> don't want to change the service code (for example using TRUNCATE
> statement instead of DELETE statement) for any reason.
>
> So I am thinking to write sql job whose job is:
> Backup transaction log and shrink log file.
>
> This job runs every day at 4:00 AM.
>
> I alreday have a full backup job which runs at 3:00 AM daily. Probably I
> will add the above commnads (backup transaction log and then shrink log
> file) to the full backup job schedule as another step.
>
> Does any one experainced this? is it write thing to shrink file every day?
>
> Thanks,
> Venkat
>
|
