Log file size growing rapidly.. increased by 1 GB every week - microsoft.public.sqlserver.server

Message from discussion Log file size growing rapidly.. increased by 1 GB every week

Venkat

View profile

More options Feb 3 2008, 3:22 am

Newsgroups: microsoft.public.sqlserver.server

From: "Venkat" <venkatara...@gmail.com>

Date: Sun, 3 Feb 2008 13:52:49 +0530

Local: Sun, Feb 3 2008 3:22 am

Subject: Log file size growing rapidly.. increased by 1 GB every week

  Reply to author
  |
  Forward
  | Print
  | View thread
  | Show original
  | Report this message
  | Find messages by this author
  

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

Reply to author Forward