Truncate transaction log files sql server 2008

Forgot your password? Search within: Articles Quick Answers Messages. Tagged as SQL. Stats How to truncate log file in SQL Server Kumar Pankaj Verma Rate me:. Please Sign up or sign in to vote. Using the code Step 1. Execute the SQL. Copy Code. Soft Technologies. Never try out to sort other's problem. Tell them the way only Podcast Making Agile work for data science.

Stack Gives Back Featured on Meta. New post summary designs on greatest hits now, everywhere else eventually. Linked Related Hot Network Questions.

Stack Overflow works best with JavaScript enabled. Just change the Auto Shrink parameter value to True. This method is applicable to all supported versions of SQL Server: , , , , , , and This is just one of the ways to quickly reduce the size of the logs. Not the greatest, but very simple and effective. Also, keep in mind that when you truncate SQL transaction logs by this guide, all previous backups made in the Full Recovery model can be discarded.

In the training courses, Microsoft recommends that only the Full mode should be used for productive databases. However, many advanced administrators deliberately set up Simple recovery mode for their databases. In this case, there is a significant increase in performance for mass insert operations and when working with large binary data, which justifies some decrease in the possibilities of backup and recovery.

What is more important for your task — additional recovery options or maximum performance, so decide for yourself. I thank you so much for this! Awesome article and thanks to you bros!! Very nice information and clearly explained. I cleared around GB from the server, which is occupied by log files. Sign up using Email and Password. Post as a guest Name.

Email Required, but never shown. The Overflow Blog. Podcast Making Agile work for data science. Stack Gives Back Featured on Meta. New post summary designs on greatest hits now, everywhere else eventually. Related 2.

Hot Network Questions. Question feed.