Category: Transaction Log

Introduction In this post I will give you a tip on how long it would be good to keep transaction logs. To understand why, basics of point-in-time recovery from backups are explained. If you are in a hurry: keep transaction …

Transaction Log Backups – How long to keep them? Read More »

There are some myths widely spread about transaction log that are to be debunked here: Log backup copies log file FALSE. Someone might think if you have 100GB log, that log backup will also be 100GB, since they think the …

Transaction log myths Read More »

Introduction What is the best practice, how to properly set-up transaction log initial size, growth, and number of VLFs? There are many articles on the net on that theme, and some of them are suggesting really wrong concepts, like setting …

Set transaction log size and growth Read More »

Transaction log truncate – why it didn’t shrink my log ? (Truncate vs Shrink) Introduction One term that makes the most confusion between people dealing with sql server transaction log is “log truncation”. In this article I’ll explain what log …

Transaction log Truncate vs Shrink vs VLF number Read More »

Introduction You got yourself in situation where transaction log has massively grown, disk space became dangerously low and you want a quick way to shrink it before server stops ? There are many articles on the net on that theme, …

Transaction log survival guide: Shrink 100GB log Read More »

Visit Us On TwitterVisit Us On FacebookCheck Our FeedVisit Us On LinkedinVisit Us On Youtube