There are some myths widely spread about transaction log that are to be debunked here: Full/diff backup will clear the transaction log FALSE. Only transaction log backup in full and bulk_logged recovery model, or checkpoint in simple recovery model will…
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…
Posted in Security and encryption
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…
Posted in Transaction log
Transaction 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 truncation is and the difference between log truncation vs log shrinking. Everything said here…
Posted in Transaction 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,…
Posted in Transaction log
