SQL Server Disaster Recovery: Recovering from Disasters Using Backups

November 2009

The main reason a backup exists is to be restored in the event of a disaster. Although most people are comfortable taking regular backups of their SQL Server databases, restoring a database from backups can be a lot more complicated. This article explains how restore works and walks you through some simple restore scenarios.