Page 148 - DCAP508_DATABASE_ADMINISTRATION

Database Administration

Notes
Figure 10.10: Restore Database Options

The Options tab in the Restore Database dialog box provides options to select the final
restore state, change the file name, and set tape options for the restore operation.
7. Select the appropriate settings in this dialog box.
Description of fields

i. Eject tapes after restoring each backup: ejects the tape when the restore operation
completes if a tape restore is being performed.
ii. Prompt before restoring each backup: displays a dialog box after each backup is
restored successfully. This option may be used when restoring multiple backups.
iii. Force restore over existing database: – forces the files for the existing database to be
initialized. This option should be used with caution as it erases the data that exists in
the selected database before starting the restore operation.
iv. Restore As: shows the original and target physical file names for the database that is
being restored.
v. Recovery completion state: determines the final state of the restored database.
vi. Undo file: a file required by SQL Server to track incomplete transactions if the
backup is restored in standby state.
8. To start the restore operation, click OK. The Restore Progress dialog box (Figure 10.11) is
displayed while the restore operation executes.

142 LOVELY PROFESSIONAL UNIVERSITY