Page 147 - DCAP508_DATABASE_ADMINISTRATION
P. 147
Unit 10: Database Backup and Restore
3. From the list of databases, select the database for which the backup has to be restored. Notes
A list of all backups performed for the selected database is displayed in the Parameters
section of the Restore Database dialog box. This information is collected from the history
tables in the MSDB database.
4. From the list of backups, select the backup to restore, then click the Properties button to
display the Backup Set Properties dialog box shown in Figure 10.9.
Figure 10.9: Backup Set Properties Dialog Box
The dialog box displays backup properties including backup type, size (in KB), start and
finish dates, server name, and media description.
5. In the Backup Set Properties dialog box, click OK.
6. In the Restore Database dialog box (Figure 10.10), click the Options tab.
LOVELY PROFESSIONAL UNIVERSITY 141
