Create a New Backup Scope for Azure SQL Backup
Procedure
To create a new backup scope for Azure SQL, follow the steps below:
- Go to the Backup page on the new UI.
-
Click on the Azure SQL service tile or click the More actions (
) button on the upper-right corner of the Azure SQL service tile and click Configure backup scope from the drop-down list.
-
In the Configure backup scope for Azure SQL page, all the existing
backup scopes for Azure SQL are listed in the table. You can use the search box
to search for the backup scopes by name and manage the columns to adjust the
view of the backup scopes.
Note: You can click the Refresh (
) button in the upper-right corner of this page to retrieve the latest data list for Azure SQL databases. The Last refreshed time is displayed next to the Refresh (
) button.
- Click the Create button and select Azure SQL backup. The Create backup scope panel appears.
-
In the Select databases step, select the tenant and the databases that
you want to add to the backup scope.
- Manually select – Select the databases that you want to add to the backup scope. You can use Filters to find the databases you want to protect or use the Search box to search for the databases via the keywords in the name. The number of your selection will be displayed on the row of the tenant name.
- Copy from existing native Azure SQL backup monitoring backup scope – Select the backup scopes from the native Azure SQL backup monitoring backup scopes drop-down list.
-
Click Next, and you will go to the Configure storage based on
region step to configure a storage profile for each region. You can
select a storage type and then select storage profiles. You can use an existing
storage profile or create a new storage profile to store the backup data for the
databases in the same region. For details on configuring storage location, refer
to Manage Your
Storage.
Note: If you have enabled a firewall for your Azure storage, you need to add the IBM® Storage Protect for Cloud IP addresses to your Azure storage account firewall or configure the firewall to allow IBM Storage Protect for Cloud agent servers running on a dedicated ARM Vnet subnet to access your storage location. For details, refer to Allow IBM Storage Protect for Cloud Agent Servers to Access Your Storage Account.
-
After you finish the storage configuration for each region, click Next
to configure the scope information, schedule, and data retention settings. Refer
to the following:
- Scope information – Enter a name and description for the scope you are creating. The description is optional.
- Schedule – Click days, weeks, months or
years as the unit of time for the monitoring job interval,
enter a number in the text box after Run a monitoring job every,
and then configure the start time for your first monitoring job. The
monitoring jobs will retrieve the information of the native Azure
backups (both PITR and LTR) and provide them as recovery points that you
can use to perform restore.Note: The days option is only available if you use your own storage to store backup data.
- Notification – Check the notification profiles which will be applied to the backup scope.
- Retention policy – Configure when to prune the backup data from the
storage location. Note that if you are using IBM storage, the retention
policy for backup data is subject to your agreement and you can
configure a custom retention period up to the retention policy in your
subscription. If you are using IBM default storage with
unlimited retention period, the Unlimited option is
selected automatically in the list. If you want to use a custom
retention period, select Custom from the list, enter a number in
the text box and select weeks, months, or years
from the drop-down list. The retention period cannot be less than 2
weeks. Note that if you have a retention policy with a fixed year in
your subscription, the maximum retention period that you can configure
will be displayed under this field.Note: When you configure the retention period for backup data using the Year unit, the Configure Full Backup Frequency section will appear. You can then select a number from the drop-down list to set the full backup frequency. If the retention period is set to more than three months using the Month or Week unit, the full backup frequency will automatically be set to three months and cannot be changed. For retention periods of less than three months, the full backup frequency will be adjusted accordingly and cannot be modified.
- Click Next to review your settings.
- Click Save to save this backup scope. The backup for the databases in this backup scope will roll out as scheduled. For more details about monitoring the backups, refer to Monitor Your Backup.