Solved

How to reduce the size of SQL Server log files

Posted on 2014-07-30
2
161 Views
Last Modified: 2014-08-03
How to reduce the size of MS SQL Server log files. I have an example where the .mdf file is 168Mb, but the .ldf file is 3Gb. I also have another where the .ldf is 189Gb.
0
Comment
Question by:BishopsWaltham
2 Comments
 
LVL 142

Accepted Solution

by:
Guy Hengel [angelIII / a3] earned 500 total points
ID: 40228530
please read up this article first for a full understanding of why the log files are getting large, followed by how to keep them "small" in normal time and how to perform a one-shot shrinking:
http://www.experts-exchange.com/Database/MS-SQL-Server/A_11077-How-to-shrink-a-bloated-log-file.html

NOTE: do not perform regular (like daily) shrinks of the database or log files, this would just be waste of IO and slow down your db operations during the day
0
 
LVL 24

Expert Comment

by:Mohammed Khawaja
ID: 40228690
Best practice is to backup your DB and then the TLOGs and ensure to select the option "truncate at checkpoint" in your backup software.  This way logs will be flushed after successful backup.
0

Featured Post

Enabling OSINT in Activity Based Intelligence

Activity based intelligence (ABI) requires access to all available sources of data. Recorded Future allows analysts to observe structured data on the open, deep, and dark web.

Join & Write a Comment

Problem: Windows 32bit running out of paging space. Solution: Add additional page files on separate partitions. Background: By default Windows creates only one page file on the partition you install Windows on. You may know that the maximu…
Have you ever stumbled upon a software that is so great that you just love? It happened to me. Love at first sight. Filezilla Server.   Ok its not the most advanced ftp server I've came across. But its a fairly simple piece of software to get the …
Here's a very brief overview of the methods PRTG Network Monitor (https://www.paessler.com/prtg) offers for monitoring bandwidth, to help you decide which methods you´d like to investigate in more detail.  The methods are covered in more detail in o…
This tutorial demonstrates a quick way of adding group price to multiple Magento products.

706 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question

Need Help in Real-Time?

Connect with top rated Experts

20 Experts available now in Live!

Get 1:1 Help Now