570
Part V: Enterprise Data Management
Performing the Restore with Management Studio
As with the backup command, you can launch the restore from within Management Studio
by following these steps:- Select the database to be restored.
- From the context or Action menu, select Tasks ➪ Restore ➪ Database to open the
SQL Server Restore database form.
The Restore Database form, as shown in Figure 21-6, does a great job of intelligently
navigating the potential chaos of the backup sequences, and it always offers only legal
restore options.
FIGURE 21-6
Only the correct sequence of restoring from multiple backup fi les is possible from
Management Studio’s Restore Database form.The selection you make at the top of the form is the name of the database after the restore.The Restore Database form can restore database backups, fi le backups, or backups from a
device (that is, a tape drive). The Restore Wizard presents a hierarchical tree of backups,
whereas the fi legroups or fi le restore lists the fi les and must be manually restored in the
correct order.c21.indd 570c21.indd 570 7/31/2012 9:22:52 AM7/31/2012 9:22:52 AM
http://www.it-ebooks.info