Disaster Recovery Week

This week we highlight the practice of being prepared for disasters at SQLServerCentral.

Disaster Recovery Planning for Data: The Cribsheet

Planning for disaster recovery and business continuity aren't amongst the most exciting IT activities. They are, however, essential and relevant to any Database Administrator who is responsible for the safety and integrity of the companies' data, since data is a key part of business continuity.

Quick and Dirty DR Solution Using Robocopy

This article covers how to use robocopy with SQL Server Agent to copy database backup files to another server.

Restoring Features

Logshipping

Disaster Recovery Planning

Preparing for the Unthinkable - a Disaster/Recovery Implementation

Functionality to help maintain a Disaster/Recovery (D/R) Environment synchronized with production is introduced and the associated challenges are discussed.

Retrieving SQL Server Permissions for Disaster Recovery

I'm needing to audit the permissions in my databases, but I want to script them out so I have something to run in case of a recovery situation. I've got the logins, roles, and users handled, but it's the permissions that I want to extract. How can I do this easily?

How well do you really know your colleagues?

Take your peers out of their comfort zone and do you know how well they'll perform?

Unteachable Disaster Recovery Techniques

There are some skills which are extensions of your instincts, and which you can only learn though years of experience. Matt Simmons has this brought home by the fact that he was recently minutes away from a data-loss disaster, and he doesn't quite know how he prevented it.