Tag Archives: Backup/Recovery

Common Problems with Backup and Recovery and How to Handle Them

Posted on September 30, 2013 by way0utwest

The basic concepts behind taking a backup are well understood, but people are frequently surprised by the many ways backups can go wrong. First, we’ll explore the most common problems around SQL Server backup and recovery, so that you can … Continue reading →

Posted in Presentations | Tagged , | 1 Comment

Losing Data

Posted on June 17, 2013 by way0utwest

Most of us that work as data professionals hate the idea of losing data. When the developer calls and says his test database is gone and backups were never set up, we may shrug our shoulders and offer to help … Continue reading →

Posted in Editorial | Tagged , , | Comments Off on Losing Data

Test Your Restores

Posted on December 11, 2012 by way0utwest

I was talking with someone the other night about their database systems and they mentioned they had implemented TDE (Transparent Data Encryption) to comply with HIPAA regulations. This person had verified that they were backing up the Database Encryption Key, … Continue reading →

Posted in Editorial | Tagged , , , | Comments Off on Test Your Restores

Verify those Backups

Posted on September 21, 2012 by way0utwest

It’s important that you backup your database. The most important thing you can do. However making backups isn’t enough: you need to verify those backups are good. A humorous short video from Grant Fritchey (b | t) and RedGate on … Continue reading →

Posted in Blog | Tagged , , , | 1 Comment