• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 190
  • 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
What is SQL Server and how does it work?

The purpose of this paper is to provide you background on SQL Server. It’s your self-study guide for learning fundamentals. It includes both the history of SQL and its technical basics. Concepts and definitions will form the solid foundation of your future DBA expertise.

 
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

Featured Post

Concerto's Cloud Advisory Services

Want to avoid the missteps to gaining all the benefits of the cloud? Learn more about the different assessment options from our Cloud Advisory team.

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