Tag Archives: backup

Losing All Traces of Data

Posted on April 28, 2016 by way0utwest

I was reading a thriller recently, in which a businessperson had their child threatened if they didn’t get some data for the criminals. Once the person had retrieved the data, they were told to delete it from the system and … Continue reading →

Posted in Editorial | Tagged | Comments Off on Losing All Traces of Data

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