Tag Archives: backup

Multiple Backup Files

Posted on January 9, 2015 by way0utwest

I’ve been writing a little PowerShell lately that will back up databases, move files, and restore them. I’m often testing things, and having scripts to quickly and easily move files is very handy. After one of my posts recently, a … Continue reading →

Posted in Editorial | Tagged , , | 2 Comments

Powershell – Copy the Latest Backup

Posted on December 29, 2014 by way0utwest

I got an email recently where someone asked me how they can refresh a dev environment with Powershell. I guess I’d written something about this in 2009, though that would have been for testing as Red Gate had already banned … Continue reading →

Posted in Blog | Tagged , , , , | 5 Comments

Backup Your Certificate for TDE

Posted on August 26, 2013 by way0utwest

If you’ve enabled TDE, you need to be sure you have a copy of the certificate that protects the Database Encryption Key (DEK). If you follow my instructions, then you have one. If you didn’t make a backup, or you … Continue reading →

Posted in Blog | Tagged , , , , | Comments Off on Backup Your Certificate for TDE

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