# Restore

The Restore option is used to restore data from the Backup database when the need arises. Select File/Restore from the Main Menu. If a backup database does not exist, the message "No files found in backup directory" is displayed.

When backups exist in the backup directory, select the database name from the drop down list which is displayed.

For Access Database : The databases with the extension .mdb will be displayed.

For Oracle Database : The database names with the extension .dmp will be displayed.

For SQL Server Database: All devices on which backups are taken will be shown in the list. For any selected device restore will be carried out. Before restore, the original device file should be on the same location from where it was taken. If the device files are copied to storage devices and deleted from the hard drives, they should first be restored to the hard drives and then Restore should be carried out.

After the database is selected, the question "Overwrite the existing database?" is displayed.

On confirmation, the message "Make sure all users are logged out." is displayed.

After you have ensured that all users have logged out, click OK to proceed.

On completion of the restoration process, the message "Restore process completed" is displayed.

The existing database will have been overwritten by the selected database.