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 …
Author: Vedran
Procedure with Execute as login?
Sometimes we need a low-privileged user to do a specific administration task or task that require some server-level permissions (such as VIEW SERVER STATE, ALTER TRACE etc). Of course, we do not want to give that account server-level privilege, because …
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 Truncate vs Shrink vs VLF number Read more »
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, …
Transaction log survival guide: Shrink 100GB log Read more »
