Tag Archives: Backup/Recovery

New Connect Item – TDE

Posted on June 29, 2011 by way0utwest

Does the certificate matter for TDE? Apparently not as I found a number of people discussing the fact that the expiration date for certificates is not checked for TDE restores. So if your certificate expires, you can still restore the … Continue reading →

Posted in Blog | Tagged , , , , | Comments Off on New Connect Item – TDE

SQL Server Default Backup Directory

Posted on June 9, 2011 by way0utwest

Someone asked me in a webinar how to change the default backup directory. I knew, but realized that I didn’t have a reference and ended up with more explanation than needed if I’d had a post. So here it is: … Continue reading →

Posted in Blog | Tagged , , , | 1 Comment

The Backup Passwords

Posted on May 26, 2011 by way0utwest

One of the things that my boss was excited to implement a few years back were passwords for our backups. Actually we were using a third party backup utility, like SQL Backup, for our SQL Server instances. We purchased the tool … Continue reading →

Posted in Editorial | Tagged | Comments Off on The Backup Passwords

Backups after a DR Restore – MCM

Posted on February 21, 2011 by way0utwest

If you have a disaster, and you need to restore to some point in time prior to the last log backup you have, what’s the first thing you should do at this point in time? Make a full backup, of … Continue reading →

Posted in Blog | Tagged , , , | Comments Off on Backups after a DR Restore – MCM