running32
asked on
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
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
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!!
"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.
I dont agree with this generalization. It depends entirely on the nature of the database and the planned backup strategy.
Has your question been answered? If so could you please close it.
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.