Tag Archives: disaster recovery

Prepare for When Disaster Strikes

Posted on July 23, 2012 by way0utwest

Abstract: A talk on disasters and what you can do to prepare for them. I look for four types of disasters, and I briefly talk about the immediate response. However we then go back and look at the ways in … Continue reading →

Posted in Presentations | Tagged , | Comments Off on Prepare for When Disaster Strikes

Prepare for When Disaster Strikes

Posted on July 13, 2012 by way0utwest

When disaster strikes you have to respond and get things fixed ASAP. However if you could turn back the clock, and think about the potential problems and possible issues, can you decrease the time it takes to get things back … Continue reading →

Posted in Presentations | Tagged , | Comments Off on Prepare for When Disaster Strikes

13 Disasters

Posted on June 11, 2012 by way0utwest

This editorial that was originally published on Aug 15, 2007. It is being rerun as Steve is traveling. This is an interesting list of disasters that can befall a production system. It comprises more than database servers, but certainly can happen to … Continue reading →

Posted in Editorial | Tagged | Comments Off on 13 Disasters

Always restore with NORECOVERY

Posted on May 24, 2012 by way0utwest

Always, always, ALWAYS restore a SQL Server database with the NORECOVERY option. It’s trivial to switch the database online. Not trivial to recover from an accidental restore with RECOVERY (the default) ‘nuff said.

Posted in Blog | Tagged , , , | 5 Comments