• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 198
  • Last Modified:

Transaction lOg is full

Developers are complaining that database transaction log is full and asking to increase it. You checked database files and found that database log is around 30% of database size. What would you do?
0
asqldba
Asked:
asqldba
  • 3
  • 2
  • 2
1 Solution
 
chapmandewCommented:
switch your databases to simple recovery mode, or start doing trans log backups.

check this article out I wrote on teh subject:

http://blogs.techrepublic.com.com/datacenter/?p=448
0
 
David WallCommented:
Run regular backups of your trans logs
0
 
David WallCommented:
Sorry didnt mean to copy didnt respond promptly
0
Ultimate Tool Kit for Technology Solution Provider

Broken down into practical pointers and step-by-step instructions, the IT Service Excellence Tool Kit delivers expert advice for technology solution providers. Get your free copy now.

 
RiteshShahCommented:
once you are done with backups, you can truncate transaction log, have a look at

http://www.sqlhub.com/2008/05/sql-server-truncate-transaction-log.html
0
 
chapmandewCommented:
once you are done with backups, there is NO NEED To truncate the logs...the backups do it for you.
0
 
RiteshShahCommented:
Hi Chapman, Yes you are abosolutly right but I have come across situation few time in past that even after backing up logs, I wasn't able to reclaim the space, that is the reason I told to truncate, if space will not be reclaimed.
0
 
chapmandewCommented:
Space is never reclaimed to the OS by a truncate or by backing up the logs.  The only way to make the file smaller is to use a shrink command, such as dbcc shrinkfile
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

Join & Write a Comment

Featured Post

Ultimate Tool Kit for Technology Solution Provider

Broken down into practical pointers and step-by-step instructions, the IT Service Excellence Tool Kit delivers expert advice for technology solution providers. Get your free copy now.

  • 3
  • 2
  • 2
Tackle projects and never again get stuck behind a technical roadblock.
Join Now