Tag Archives: Backup/Recovery

Backups Over Time

I’ve written about backups at various times, including responsibility, problems with systems, and home protection. This is a subject that is important to me, as I consider the responsibility for protecting data to be first and foremost. Security, performance and … Continue reading

Posted in Editorial | Tagged

Converting SQL Backup Files to MTF

I got a copy of some backup files recently and needed to restore them. However, I don’t have SQL Backup installed on all my instances. It’s not a big deal to install it, but since this is a one-off, I … Continue reading

Posted in Blog | Tagged , , , ,

Restoring a Striped Backup–#SQLNewBlogger

Another post for me that is simple and hopefully serves as an example for people trying to get blogging as #SQLNewBloggers. Recently I uncompressed some SQL Backup Pro files. Since multiple threads were used to make the backup, I ended … Continue reading

Posted in Blog | Tagged , , , , | 2 Comments

The Writeable Warm Standby

I saw a question recently that went like this: I get one full backup from FTP. I’ll get daily log backups through FTP after this, but never another full. I need to restore this daily log backup and allow the … Continue reading

Posted in Blog | Tagged , , ,

The Log Chain

I ran across a question recently from someone that received a similar message to the one showed in this image: In this case, the log chain is broken. I’ve received this message, usually from a script that is automatically restoring … Continue reading

Posted in Blog | Tagged , , ,

Attaching All Databases with PowerShell–Refactoring out Write-Host

Someone posted a note to me on Twitter that noted that Write-Host is not recommended for your scripts. I checked the link to an MSDN blog on Write-Host Considered Harmful, and it made some sense. Basically it says that since … Continue reading

Posted in Blog | Tagged , , , ,

Attaching All Databases with PowerShell – The Overview

TL;DR Script is here: Git Hub Powershell Scripts. It’s the attachdbs.ps1 and will attach all databases in a folder to a SQL Server instance, if they don’t exist. I wrote a PowerShell script recently to actually accomplish a task I … Continue reading

Posted in Blog | Tagged , , , ,

The Development Backup

Have you ever had a development server crash? Have you lost work because of this? Had delays or had to recreate code? You shouldn’t, or at least you shouldn’t lose much work or time.. There was a time when I … Continue reading

Posted in Editorial | Tagged , ,

Backup Responsibility

One of the most important things that you can do as a DBA, or really as any sort of system administrator, is back up your system.Ensuring that you have have backups, and of course, that you can restore them, is … Continue reading

Posted in Editorial | Tagged , , | 1 Comment

How Often Do I Backup my Log?

Do you know how often to back up your transaction log in SQL Server? Most of us have stock answers, hopefully answers that have time intervals like every hour. I worry that most people have a time interval of “never” … Continue reading

Posted in Editorial | Tagged | 4 Comments