Skip to main content

Restore a database

After you create a database backup, it's available for restore as follows:

  • In non-production and pre-production star systems, the created backups are available to all other planets within a star system.
  • For production star systems, the database backups become automatically available in a pre-production star system. They aren't available in the production star system. You can't restore backups to the production planet.
    For details on restoring a production backup on a pre-production planet, see Deploy InsuranceSuite apps to production planets.
Note:

Access to this application is managed by Guidewire Hub. For details, see Access Cloud Platform apps and services.

Server modes of database backup and target planet​

During restoration of a database backup, all the InsuranceSuite apps on the target planet are redeployed. During the redeployment, when the server mode of a database backup is different than the server mode of a target planet, you can choose in which server mode the apps on the target planet will be redeployed.

On non-production (development) and pre-production planets, you can change the server mode at any time in the Settings tab. For details, see Change the server mode.

Notification during restoration of a backup with the selection of the server modes.

Restore a database backup​

To restore a database backup:

  1. From Apps, select Database Backups or select it from your pinned apps.

  2. In the Backups tab, hover over a backup that you want to restore and select Restore.

    Database backups view with restore action.

  3. From Planet to restore, select a planet to which you want to restore the database backup.

  4. In Retain data tables, select the data tables that you want to keep. The data in the selected tables won't be overwritten by the backup.

  5. Select Restore.

    For each available InsuranceSuite app, the system selects values for the Branch and Build # / Dockerize # fields. These values represent the code version associated with the database backup schema at the time when the backup was created.

    If you choose a different build by specifying the values in Branch and Build # / Dockerize #, make sure this build is compatible with the database schema.

  6. After you verify or update the Branch and Build # / Dockerize # numbers, select Restore.

    The Database Backups app will redeploy the apps on the target planet, with the selected database backup.

    If the database backup and target planet have different server modes, there is an additional notification. For details, see Database backup and target planet server modes.

Known limitations​

The following are known limitations for restoring database backups:

  • You can't restore snapshot backups that are incompatible with the AWS Aurora Postgres cluster version.
  • You can't retain data tables with foreign key constraints.