Planning for Disaster

There is a certain paradox in being advised to expect the unexpected, but the DBA must plan and prepare in advance to protect their organisation's data assets in the event of an unexpected crisis, and return them to normal operating conditions. To minimise downtime in such circumstances should be the aim of every effective DBA. To plan for recovery, It pays to have the mindset of a pessimist.

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?