Database Restore job

The Database Restore job restores an OpenEdge backup to the location specified in the existing structure for that database. If the file structure does not exist, then the restore is performed to the existing directory for all of the areas and extents.

To complete the Database Restore Properties page:

  1. Provide values for the Name and Description fields.
  2. Identify the restore device you are using:
    • If you select Tape, you must also define the absolute path for the tape device.
    • If you select Disk, you must also specify the directory and file name.
    • Note: If you used the volume size (-vs) parameter when backing up your database to disk, you must specify the file that contains the names of each volume. The Restore job will pass this file to the OpenEdge Restore (PROUTIL) utility. The name of the file should be <database name>-restore.txt. The contents of the restore file should be the same as the contents of the backup file passed to PROBKUP. See Step 4 under the "Database Backup jobs" section for more information about the backup file.

  3. Provide the name of the database you intend to restore in the Restore to field. This name is the full path and name of the database to which you want to restore. If you want to overwrite an existing database at this location, select the Overwrite database option.
  4. Complete the following fields:
    • Partial verify (-vp) Select if you want to ensure that a partial verification of the completed backup occurs. It only ensures that the backup can be read.
    • Note: This option does not restore the database.

    • Full verify (-vf) — Select if you want a full verification of the completed backup. This process ensures that a block-by-block comparison is performed between the backup and the database.
    • Note: This option does not restore the database.

    • List structure (-list) — Select to create a structure file from the backup that was completed.
    • Note: This option does not restore the database.

    • No verification — Deselect if you want verification. Note that No verification, indicating that no verification process will occur, is the default selection.
  5. Verify the name of the command's current working directory in the Working Directory field. If specified, this directory must exist. This property defaults to the working directory defined at installation.
  6. To append subsequent messages to the .out or .err files, select the Append option. The Output file field indicates where messages will be retained.
  7. Select the Debug log file option to obtain diagnostic details that help debug job properties when setting up a job. For example, you can set this option and use the Run Now feature on the Job Summary page. Once you have submitted the job, Fathom makes debug data available through the debug log file link on the Job Summary page.
  8. If you intend to set up actions and alerts for this job, click the Edit button associated with the Completion Actions and Alerts field to display the optional Job Completion Actions and Alerts page. The Job Completion Actions and Alerts page appears. See the Resource Monitoring Guide for more information about the Job Completion Actions and Alerts page.
  9. Click Save. The Job Summary page appears. You can now schedule the job or run it immediately. You can also edit advanced information. See the "Advanced information" section for steps on editing advanced information.

Copyright © 2004 Progress Software Corporation
www.progress.com
Voice: (781) 280-4000
Fax: (781) 280-4095