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.
Figure 1. Selection of the backup option -
Click Run to run a manual backup.
Figure 2. View of Run backup -
When the backup starts, some features might not be available until the backup is completed.
Figure 3. View of the backup initiation -
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.
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:
-
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.
Figure 5. View of the selection of the end-of-backup restore option -
Click Restore to initiate the restore.
Figure 6. View of Restore backup -
An information message appears when restore has started. Some features might not be available until restore is completed.
Figure 7. Start of the end-of-backup restore -
A progress bar indicates the progress of the restore process.
Figure 8. Progress of the end-of-backup restore -
Notifications show a Restore success! message after the restore is completed.
Figure 9. Successful completion of end-of-backup restore
Point-in-time restore
IBM Db2 SaaS 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).
Figure 10. View of the selection of the point-in-time restore option -
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.
Figure 11. View of date and time selection for point-in-time restore -
Restoring the database to the selected point in time.
Figure 12. View of the point-in-time restore initialization -
The restore operation completed successfully.
Figure 13. View of the successful completion of the restoration