Category: Transaction log and Recovery

Database Recovery from RAM

Introduction Recently I had a client who basically lost his SQL Server databases. I decided to share this experience with you, so you can use it if you ever find yourself in so tough situation. The client found out that

Posted in Transaction log and Recovery

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

Posted in Transaction log and Recovery

Disk failure probability on a large number of disks

Introduction We either have or will experience a drive failure. Doesn’t matter if we talk about HDD, SSD, or PCIe disks, any storage disk drive will fail eventually. But how probable it really is, especially if we have many drives?

Posted in Transaction log and Recovery

Transaction log myths

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

Posted in Transaction log and Recovery

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 and Recovery

Transaction log Truncate vs Shrink

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

Posted in Transaction log and Recovery

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 and Recovery
Visit Us On TwitterVisit Us On FacebookVisit Us On LinkedinVisit Us On YoutubeVisit Us On Google PlusCheck Our Feed