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 …
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 – 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 »
