IBM Cloud Docs
Backup and restore

Backup and restore

Backup

For paid plans, encrypted backups of the database are done daily. A daily backup is kept for each of the last 14 days.

All paid plans make use of Cross-Regional IBM Cloud Object Storage (COS), by default, to keep backups offsite.

Changing the backup time can take upto 2 hours to take effect.

The following is an example of the manual backup operation in the web console UI:

Enterprise and Standard plans

  1. Click Administration in the left menu and select the Backups tab. Click the Run backup button.

    View of the highlighted selection of the backup option
    Figure 1. Selection of the backup option

  2. Click Run to run a manual backup.

    View of Run Backup page option
    Figure 2. View of Run backup

  3. When the backup starts, some features might not be available until the backup is completed.

    View of the backup initiation
    Figure 3. View of the backup initiation

  4. After backup completion, a new backup entry in the list of backups appears as a Full (Manual) type. The new backup is in an available state.

    View of completed backup
    Figure 4. View of a completed backup

Restore

All paid plans make use of Cross-Regional IBM Cloud Object Storage (COS), by default, to keep backups offsite.

For information about point-in-time restores, see Point-in-time restore.

End-of-backup restore

Enterprise and Standard plans

The following is an example of the end-of-backup restore operation in the web console UI:

  1. Click Administration in the left menu and select the Backups tab. Select a backup that you want to restore to end-of-backup and click Restore.

    View of the highlighted selection of the end-of-backup restore option
    Figure 5. View of the selection of the end-of-backup restore option

  2. Click Restore to initiate the restore.

    View of Restore backup screen option
    Figure 6. View of Restore backup

  3. An information message appears when restore has started. Some features might not be available until restore is completed.

    Start of the end-of-backup restore
    Figure 7. Start of the end-of-backup restore

  4. A progress bar indicates the progress of the restore process.

    Progress of the end-of-backup restore
    Figure 8. Progress of the end-of-backup restore

  5. Notifications show a Restore success! message after the restore is completed.

    Successful completion of end-of-backup restore
    Figure 9. Successful completion of end-of-backup restore

Point-in-time restore

Db2 on Cloud added a point-in-time restore capability for systems in IBM Cloud Public. You can restore to an exact point in time from your backups.

The following are a selected example of screen captures of the point-in-time restore operation in the web console UI:

Enterprise and Standard plans

  1. Click Administration in the left menu and select the Backups tab.

  2. Click the down arrow beside the Run backup button. Select Restore (point-in-time).

    View of the highlighted selection of the point-in-time restore option
    Figure 10. View of the selection of the point-in-time restore option

  3. Select a point-in-time date to which you want to restore the database. The point-in-time restore process selects the backup closest to your requested point-in-time date out of the pool of retained backups made during the previous 14 days.

    The point-in-time restore process invalidates any of the previously retained backups with dates after the selected point-in-time date because of a resultant divergence in the timeline.

    View of date and time selection for point-in-time restore
    Figure 11. View of date and time selection for point-in-time restore

  4. Restoring the database to the selected point in time.

    View of the point-in-time restore initialization
    Figure 12. View of the point-in-time restore initialization

  5. The restore operation completed successfully.

    View of the successful completion of the restoration
    Figure 13. View of the successful completion of the restoration