Create a Database: From Backup



New Database From Backup - Studio Databases View

Figure 1. Create New Database From Backup

Create New Database From Backup

  1. Click on the Databases tab in the Studio.
  2. Click the down arrow on the New database button.
  3. Select New database from backup

New Database From Backup - Studio Backups View

Another way to access the New Database From Backup interface is via the Studio Backups view.
Figure 1. Create New Database From Backup

Create New Database From Backup

  1. Click the Tasks tab and select Backups.
  2. Click the Restore a database from a backup button.

Backup Source Configuration

Figure 2. Backup Source Configuration

Backup Source Configuration

  1. Name your new database.

  2. Source
    Select the source server type to see the fields necessary to access the backup

    • If you use an Amazon S3 custom host: ForcePathStyle
      • a- Use a custom S3 host
        Toggle to provide a custom server URL.
      • b- Force path style
        Toggle to change the default S3 bucket path convention on your custom Amazon S3 host.
  3. Backup Directory
    Select the file location that you set when you created your backup.

    • If your source is a cloud-based database, you will likely need to enter credentials and passwords as well as location.
  4. Disable ongoing tasks after restore
    Disabling will likely require ongoing tasks to be created again.

  5. Skip indexes
    Skipping indexes will require your indexes to be built anew.

  6. Restore Point Choose the backup version which will populate your new, restored database.

    • Snapshot backup type includes fully built indexes which makes restoring the database faster.
    • Full or Incremental types include index definitions from which the new indexes will be built.

Setting Up High Availability After Restoration

The backup will be restored only on the current node after restoration.
To create a database group of at least 3 nodes this database can be added to other nodes using the "Add node" button in the Manage group Studio view.