up vote 2 down vote favorite
1
share [g+] share [fb]

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

link|improve this question
29% accept rate
feedback

2 Answers

up vote 3 down vote

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

link|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
feedback
up vote 2 down vote

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

link|improve this answer
feedback

Your Answer

 
or
required, but never shown
discard

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