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:

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

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.

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

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:

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