Take the 2-minute tour ×
Server Fault is a question and answer site for professional system and network administrators. It's 100% free, no registration required.

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

2 Answers 2

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 ? –  Albert Widjaja 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.

http://support.microsoft.com/kb/873235

share|improve this answer

Your Answer

 
discard

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.