Category: Transaction Log

Transaction Log Backups – How long to keep them?

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 myths

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

Set transaction log size and growth

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

Transaction log Truncate vs Shrink vs VLF number

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 survival guide: Shrink 100GB log

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,

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