Overview
IBM® Netezza® Performance Server for IBM Cloud Pak® for Data as a Service supports full, differential, and cumulative backups that you might run on demand or according to a schedule. If you want to run differential and/or cumulative backups, run a full backup first. If you want to restore differential and/or cumulative backups, restore a full backup first.
You cannot backup (nzbackup) and restore (nzrestore) external data source objects.
Scheduled backups
A scheduled backup is a backup of the existing database that runs on a schedule.
You can configure your backup schedule based on the following factors.
-
Frequency (in order of priority)
- Monthly
- Weekly
- Daily
-
Level (in order of priority)
- Full
- Differential
- Cumulative
If there is a schedule overlap, you are notified about it. You also receive information about which schedule takes precedence and why. You cannot schedule backups for the same frequency to start at the same time if there is any intersection of databases between the backup schedules. If there is no preexisting full backup to reference, you cannot perform a differential or cumulative backup.
On demand backups
An on demand (ad hoc) backup is a backup of the existing databases that runs only once and on demand. You can create on demand backups before you do any alterations on your system.
On demand backups support different backup levels:
- Full
- Differential
- Cumulative
Destination buckets
To create backups, you must have a destination bucket setup created.
For NPSaaS, you can choose between the following destinations.
- Amazon S3
- Azure Blob Storage
- IBM Cloud Object Storage
Creating destination buckets
You can create a destination bucket for Amazon S3, Azure Blob Storage, and IBM Cloud Object Storage by using the web console.
For Amazon S3
- Log in to the web console.
- Go to Backup and restore > Destinations.
- Select
Amazon S3
as your destination bucket. - Type a bucket name.
- Provide an access key ID.
- Select a region.
- Type your secret key.
- Click Save.
For Azure Blob Storage
-
Log in to the web console.
-
Go to Backup and restore > Destinations.
-
Select
Azure Blob Storage
as your destination bucket. -
Type a container name. To view the container name, in the Azure portal, go to Storage accounts -> Containers.
-
Select a blob type.
-
Select a region.
-
Type an account name. To view the account name, in the Azure portal, go to Storage accounts.
-
Type your account key. To view your account key, in the Azure portal, go to Storage Accounts > your_account > Access keys > Show keys > key1 > Key.
-
Click Save.
For IBM Cloud Object Storage
- Log in to the web console.
- Go to Backup and restore > Destinations.
- Select
IBM Cloud Object Storage
as your destination bucket. - Type a bucket name.
- Type your access key ID.
- Type your endpoint URL.
- Type your secret key.
- Click Save.