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
-
Click Administration in the left menu and select the Backups tab. Click the Run backup button.
-
Click Run to run a manual backup.
-
When the backup starts, some features might not be available until the backup is completed.
-
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.
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:
-
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.
-
Click Restore to initiate the restore.
-
An information message appears when restore has started. Some features might not be available until restore is completed.
-
A progress bar indicates the progress of the restore process.
-
Notifications show a Restore success! message after the restore is completed.
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
-
Click Administration in the left menu and select the Backups tab.
-
Click the down arrow beside the Run backup button. Select Restore (point-in-time).
-
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.
-
Restoring the database to the selected point in time.
-
The restore operation completed successfully.