Server Fault is a question and answer site for system and network administrators. It's 100% free, no registration required.

Sign up
Here's how it works:
  1. Anybody can ask a question
  2. Anybody can answer
  3. The best answers are voted up and rise to the top

I administer an a MS SQL server 2005 DB. Rececently I have discovered that the log file has grown exceedingly large. It has grown from about 50 MB to 117 GB. What causes this and how do I reduce it? Thanks

share|improve this question

Joeqwerty is right, you need to backup your log files, otherwise they will continue to grow until you run out of disk space.

Depending on your environment, if you don't need the log backups, then you can set your Database's recovery model to "Simple". This will also help to keep the log files from growing out of control.

HTH, Dan

share|improve this answer
ok, so the proper steps is: 1. perform SQL DB maintenance plan - Shrink - On Demand (from DB maintenance plan) 2. perform full backup of the DB 3. set the DB to be simple recovery mode ? – Server System Specialist Apr 15 '11 at 1:30

This is caused by not backing up and shrinking the log file. You need to backup and then shrink the log.

share|improve this answer

Your Answer


By posting your answer, you agree to the privacy policy and terms of service.

Not the answer you're looking for? Browse other questions tagged or ask your own question.