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.
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
From the Start Menu, select All Programs | Microsoft SQL Server 2005 | SQL Server Management Studio.
In the Connect to Server dialog box, click the Connect button.
From the Standard toolbar, click ...