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

trying to figure out how come my disk space was so low I discovered a log file occupying over 12Gb...

  • is this normal?

  • how do I prevent this from happening again if not?

  • do I just delete it?

Any ideas? Thanks :)

share|improve this question
7  
Whatever you do don't delete it just yet ok. –  Chopper3 Jan 14 '11 at 17:34
1  
And whatever you do, make sure it's not still set to the default 10% unrestricted autogrowth.... GOD I wish MS would change that default. –  squillman Jan 14 '11 at 19:01

2 Answers 2

up vote 13 down vote accepted

If it is a SQL Server .ldf transaction log file, you should not delete it since it would render yor database inoperable (You can't delete it if the database is online).

Assuming it is a database log file, depending on the database recovery mode and autogrow settings, when recovery mode is set to Full or Bulk Logged and autogrow enabled, your transaction log will grow until you execute a transaction log backup.

The easiest way of emptying the transaction log is to set the database recovery mode to Simple, and then shrinking the transaction log, but that will limit your recovery only to full backups.

If it is a production system and you want to be able to do a point in time restore, you need to schedule regular transaction log backups that will clear the transaction log file. It will not decrease the size on disk though, you should shrink it once to a manageable size, then monitor the usage and set it to a size that allows the transaction logs between every backup to be written to the log file without having to grow the file.

share|improve this answer

Here is some reading that will assist you with understanding both what is currently going on in your environment and most importantly what you need to be doing to manage it.

Transaction Log Management

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.