Go Premium for a chance to win a PS4. Enter to Win

x
  • Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 1117
  • Last Modified:

What are the LDF and MDF files and how can I stop the LDF from growing too large

What are the LDF and MDF files and how can I stop the LDF file from growing too large
0
running32
Asked:
running32
  • 3
1 Solution
 
mikoshaCommented:
MDF is primary data file.
LDF is a log file.
So to stop your ldf file to grow it's easy : just run log  backup or full database backup .Other option is to truncate a log.
0
 
ShogunWadeCommented:
You can also (depending on the backup strategy planned) set the recovery mode to "Simple"  this will keep the log file to a minimum. but will provent you from doing log (intremental) backups as you do not have a full log.
0
 
pegasysCommented:
You can 'shrink' the database from time to time via the Enterprise manager. Yet, I wouldnt advise you stopping the logging. It can be a lifesaver when all hell breaks loose in a ghastly crash!!

0
 
ShogunWadeCommented:
"Yet, I wouldnt advise you stopping the logging"

I dont agree with this generalization.   It depends entirely on the nature of the database and the planned backup strategy.

0
 
ShogunWadeCommented:
Has your question been answered?   If so could you please close it.
0

Featured Post

How to Use the Help Bell

Need to boost the visibility of your question for solutions? Use the Experts Exchange Help Bell to confirm priority levels and contact subject-matter experts for question attention.  Check out this how-to article for more information.

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