Database recovery IMPORTANT rule
Recently, I had a case with a customer in a really difficult situation. They accidentally deleted important data and didn’ know how to recover, a sad story. Here is how it went (I’m paraphrasing the dialog):
Category: Backup and Recovery
SUSPECT database
Recently I had a customer case with a “suspect” database. In that state database is not accessible (not online), and users could not work. First thing to look is the SQL error log. There we could see a time when …
Crypto-virus resistent backup
Funny hacker in action on his keyboard
Introduction Crypto-viruses encrypt your data. If it asks money (a ransom) to decrypt, we call them “ransomware”. They cannot can encypt your SQL Server databases, but because sql data and log files are in use by sqlservr.exe process, they first …
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 …
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 Backups – How long to keep them? Read more »
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? …
Disk failure probability on a large number of disks Read more »
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 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 »
