Test Your Restores. TEST. YOUR. RESTORES.

Test Your Restores. TEST. YOUR. RESTORES.

In the past few months I've had not one but two shining examples of how having a backup strategy meant absolutely nothing when it came time to restore from a disaster. All the backup planning in the world is completely useless if you can’t successfully restore your backups. The Ransomware I had a client that was hit by a ransomware virus, encrypting several of their systems including the database server. Not to worry, though, they had "full backups" of all the affected machines, done by a third-party backup utility. After taking a day to cleanse their network, they restored these…
Read More

SQL Server Backup Terminology Part 1: Media Sets & Backup Sets

When backing up a database or transaction log, SQL Server needs to know two basic things: What information the backup should contain Where it's going to be written Many options exist to control the contents and behavior of a backup: whether it's full, differential, or a log, if it should be compressed, copy_only, encrypted, the list goes on and on. Most people will learn these options, understand their effects, and consider themselves to have mastered SQL Server backups. While they're not totally wrong, there's still a lot more to the story: where the backups are going. While it's incredibly simple to use…
Read More