Configure disaster recovery across SharePoint farms by using SQL Server log shipping

This article describes how to use Microsoft SQL Server 2005 or Microsoft SQL Server 2008 log shipping to create a disaster recovery farm in a geographically distributed data center for Microsoft Office SharePoint Server 2007 with Service Pack 2 (SP2). By using this configuration, you can provide a disaster recovery site that provides current search results when a failover occurs. The article assumes that you are familiar with the concepts and terms presented in Plan for availability (Office SharePoint Server).

Disaster Recovery for SQL Server Databases

High-Availability depends on how quickly you can recover a production system after an incident that has caused a failure. This requires planning, and documentation. If you get a Disaster Recovery Plan wrong, it can make an incident into a catastrophe for the business. Hugo Shebbeare discusses some essentials, describes a typical system, and provides sample documentation.

7 Ways To Crash a Database

Many articles on database administration take the perspective of trying to help you do your job better. We thought we might take a different tack and poke a little fun at some of more egregious mistakes we've seen over the years at IT shops.

SQL 2005 Disaster Recovery Scripts: To Setup and Remove Mirroring

Two sets of scripts to help setup mirroring or remove mirroring - handy during disaster recovery exercise

A Simple DR Solution

Tjay Belt brings us a quick and easy DR solution that might provide you some protection if you don't have a DR plan and want some lessons learned in this area.

A Story of the Deleted Transaction Log

James DiMauro brings us a story of how a transaction log was deleted and then recreated. (from July 2008)

Rebuilding the SQL Server master database - Part 1

So, how do you prepare for a master rebuild and what do you do afterwards? Hopefully this checklist will give you an idea.

SQL Server Disasters with Preventive Measures

Have you seen disasters in your environment? I would bet you have at some point. Let's see if our top 13 disasters matches your experiences.

Rebuild Master

Recovery