To
restore a database from disk :
Select Restore Database from the main console.
Note: You can also select Restore Database from the Database menu.

Make sure that Restore is selected from the Restore window.
Click OK. The Restore Database window is displayed.

Click Next. The Restore Wizard window is displayed.

Select a database by clicking on the field under Database Name. A drop-down list of databases available on the server appears.
Select a database. The Restore Database Configuration [dmconfig.ini] From field shows the default location of the configuration file. If you moved the dmconfig.ini

If you moved the backup history file to a new location, then enter the new path or click on the browse button in the Get History File From field.
Note: After the database to be restored has been chosen, the location of the history log file should appear in the Get History File From field.
Click Next. The Copy Current Journal File page is displayed. The current journal file is then copied to a temporary directory so that the database can be restored to the condition it was in just before shutdown or failure. If the current storage media is unstable, you can specify another location for storing the current journal file in the Copy to Directory column.

Make sure that the correct temporary directory location for the current journal file is displayed in the Temp Directory field.
Select a backup that contains the files you wish to restore from the top list. The logical file names, backup files, and physical files are displayed in the bottom list.

Click Next. The Restore File Object Files window will open.
Note: The Restore File Object Files window only opens if file objects were previously backed up. Otherwise, the Restore Incremental Backup Files page will open
Select whether to restore system file objects or both system and user file objects by checking the appropriate box. File objects that will be restored appear black in the list; file objects that will not be restored appear gray.

Click Next. The Restore Incremental Backup Files page will open.

The Incremental Backup File Name field shows all the incremental backup files. If you need to change the incremental backup file path, enter a path in the Incremental Backup File Name field. You can edit the file path but must not skip restoration of any of the files.
Click Next.

If you need to restore journal files created after the last incremental backup was made to the database, make sure that the Restore Crash Journal Files check box is selected. Clearing this check box will prevent you from restoring the journal files after the last incremental backup.
Enter the backup journal file path and file name in the Crash Journal Files field.
Note: The current journal files that were copied into a temporary directory are used to restore the database to its condition just prior to shutdown.
Click Finish. Restoration is complete.
Related Topics: