Recovering a Database

In the previous section, you performed different kinds of backups but considered the recovery process only in theory. Now you will see how to restore a database in different recovery scenarios.

Retrieving Backup Information

Before you can start restoring databases, you need to know which backups you need to restore. SQL Server stores backup history about every single backup performed on databases in the msdb database. The msdb database can be queried to find the backups to restore.

Creating Simple Backup Information

1.
From the Start Menu, select All Programs | Microsoft SQL Server 2005 | SQL Server Management Studio.
2.
In the Connect to Server dialog box, click the Connect button.
3.
From the Standard toolbar, click ...

Get Microsoft® SQL Server™ 2005: Applied Techniques Step by Step now with the O’Reilly learning platform.

O’Reilly members experience books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.