Tag Archives: backup

Using xp_delete_file

Posted on October 9, 2017 by way0utwest

First, this is an undocumented proc, and there’s nothing in BOL on this. Second, it’s a holdover from previous versions, so you’d be better served by using Powershell or some other type of scripting mechanism. This procedure is not supposed … Continue reading →

Posted in Blog | Tagged , , | 2 Comments

Backups Aren’t Backups Until a Restore Is Made

Posted on February 8, 2017 by way0utwest

One of the interesting things I saw in the recent GitLab outage and data loss was the fact that none of their backups were available. They use PostgreSQL and I’m not familiar with the ways in which the modern PostgreSQL … Continue reading →

Posted in Editorial | Tagged , | Comments Off on Backups Aren’t Backups Until a Restore Is Made

Wow. Just Wow

Posted on November 21, 2016 by way0utwest

Wow. Just Wow. Yes, I meant to use a capital letter there. The Red Cross’ Blood Service in Australia had database backups on a website that anyone could access. That means that anyone could download the backup, which contained PII … Continue reading →

Posted in Editorial | Tagged , | Comments Off on Wow. Just Wow

Why We Need Backups First

Posted on September 17, 2016 by way0utwest

One of the things I show when I talk about TDE is that the backup of the certificate is very important. When you create a certificate, SQL Server warns you right away that a backup of the certificate is needed. … Continue reading →

Posted in Editorial | Tagged , | Comments Off on Why We Need Backups First