Tag Archives: Backup/Recovery

Attaching All Databases with PowerShell – The Overview

Posted on May 20, 2014 by way0utwest

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 , , , , | Comments Off on Attaching All Databases with PowerShell – The Overview

The Development Backup

Posted on May 20, 2014 by way0utwest

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 , , | Comments Off on The Development Backup

Backup Responsibility

Posted on May 9, 2014 by way0utwest

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?

Posted on February 12, 2014 by way0utwest

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