Restoring to a new database

You can create a new database and then restore a full database backup image to it. If you do not create a new database, the restore utility creates one.

When restoring to a new database, the restore utility:
  • Creates a new database, using the database alias name that was specified through the target database alias parameter. (If a target database alias was not specified, the restore utility creates the database with an alias that is the same as that specified through the source database alias parameter.)
  • Restores the database configuration file from the backup image.
  • Sets NEWLOGPATH to the value of the logpath database configuration parameter if NEWLOGPATH was specified on the RESTORE DATABASE command. Validates the log path: If the path cannot be used by the database, changes the database configuration to use the default log path.
  • Restores the authentication type from the backup image.
  • Restores the comments from the database directories in the backup image.
  • Restores the recovery history file for the database.
  • Overwrites the code page of the database with the codepage of the backup image.