Implementing Restore Scenarios for SQL Server Databases

A restore scenario is a process that restores data from one or more backups and recovers the database when the last backup is restored. For an introduction to the types of restore scenarios that are available a recovery model, see Overview of Restore and Recovery in SQL Server.

In This Section

Topic Description

Planning and Performing Restore Sequences (Full Recovery Model)

Discusses how to plan for and perform a restore sequence.

Performing a Complete Database Restore (Simple Recovery Model)

Describes how to perform a complete database restore under the simple recovery model, and includes an example.

Performing a Complete Database Restore (Full Recovery Model)

Describes how to perform a complete database restore under the full/bulk-logged recovery models, including an example.

Performing Online Restores

Contains information about performing online restores and references examples of online restores.

Performing File Restores (Simple Recovery Model)

Discusses how to restore file backups that arer taken on a simple-model database.

Performing File Restores (Full Recovery Model)

Discusses how to restore file backups that are taken on a full-model database.

Performing Page Restores

Contains information about performing page restores and provides an example.

Performing Piecemeal Restores

Contains information about performing piecemeal restores and provides an example.

Recovering a Database Without Restoring Data

Discusses how to recover a database without restoring data from a backup.

Examples of Restore Sequences for Several Restore Scenarios

Contains examples of piecemeal restore scenarios and online and offline file restore scenarios.

Responding to SQL Server Restore Errors Caused by Damaged Backups

Discusses how to respond to restore errors.

Backup and Restore Considerations for Related Features

Contains information about the operation of other features with respect to file backup and restore in SQL Server 2005.

See Also

Concepts

Backup Overview (SQL Server)
Overview of Restore and Recovery in SQL Server
Working with Transaction Log Backups

Other Resources

Backing Up and Restoring Full-Text Catalogs
Backing Up and Restoring Databases and Transaction Logs
Backing Up and Restoring Replicated Databases
Creating Full and Differential Backups of a SQL Server Database
Working with Restore Sequences for SQL Server Databases

Help and Information

Getting SQL Server 2005 Assistance