Tag Archives: backup

Using Backup-DbaDatabase for a Quick Backup

Posted on October 16, 2017 by way0utwest

I really like the dbatools project. This is a series of PowerShell cmdlets that are built by the community and incredibly useful for migrations between SQL Servers, but also for various administrative actions. I have a short series on these … Continue reading →

Posted in Blog | Tagged , , , | Comments Off on Using Backup-DbaDatabase for a Quick 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