Tag Archives: backup

Restoring a TDE Database on a New Instance

Posted on August 19, 2013 by way0utwest

You’ve enabled Transparent Data Encryption (TDE) on one of your databases, and the server has failed. How do you get this database working on a new instance? This short post will show you how this works. Files Needed There are … Continue reading →

Posted in Blog | Tagged , , , , | Comments Off on Restoring a TDE Database on a New Instance

The DBA Team #1–Code and Slides

Posted on March 27, 2013 by way0utwest

Our first DBA Team event, in Richmond, VA just before SQL Saturday #187 went well. Overall I think our experiment was a success and we’re already talking about where and when we might do this again. In the meantime, we … Continue reading →

Posted in Blog | Tagged , , , , , , | 2 Comments

The Backup Process

Posted on March 18, 2013 by way0utwest

I was reading Scott Hanselman’s post onThe Computer Backup Rule of Three, and I completely agree with him. If things are important, three copies are the minimum you should keep. I have had backups before, but I’ve found that when … Continue reading →

Posted in Editorial | Tagged , , | Comments Off on The Backup Process

Home Backup for the DBA

Posted on August 17, 2012 by way0utwest

I’ve been giving a Prepare for When Disaster Strikes talk at SQL in the City this year, and it’s designed to get you to think about problems before they happen and take steps to mitigate issues. It’s important at work, … Continue reading →

Posted in Blog | Tagged , , | 4 Comments