571
Chapter 21: Backup and Recovery Planning
21
The Backup Sets to Restore option displays the available backups. Management Studio uses the
backup history in the msdb system database and creates a restore plan. For example,
under the full recovery model, the restore plan selects the full database backup followed by
the most recent differential database backup (if available) followed by subsequent log backups.If the database is in Full or Bulk-Logged recovery mode and you did not already take a tail-log backup, the Restore
Database form will automatically select the option for you under the Options page to perform a tail-log backup.If the backup history, stored in msdb, is not available — because the server is being rebuilt
or the database is being restored to a different server — then use the Restore: From Device
option to manually select the specifi c backup disk fi le and backup instance within the fi le.The process of one full backup, the second differential backup, and the following 15 trans-
action-log backups can be correctly sequenced by selecting the fi nal transaction log to be
restored. Restoring the 17 backup fi les is performed with a single click of the OK button.If one of the backup fi les being restored is a transaction log, the Point in Time Restore option
becomes available because only a transaction log can restore some of the transactions. The
point-in-time restore will restore all transactions committed before the time selected. A new
option introduced in the Restore Database form SQL Server 2012 is the Backup Timeline form,
as show in in Figure 21-7. You can access this dialog by clicking on the Timeline button on the
Restore Database (General page) pane. This Backup Timeline dialog gives you an easy, visual
indicator to help select which point-in-time you’d like to restore the current database to.FIGURE 21-7
The Timeline.c21.indd 571c21.indd 571 7/31/2012 9:22:52 AM7/31/2012 9:22:52 AM
http://www.it-ebooks.info