Recovering Azure-protected assets
NetBackup lets you restore Azure SQL database and Azure SQL managed database assets that are backed up by Microsoft Azure. The supported backup modes are Point-in-time backup and Long-term retention backup.
Before proceeding make sure that you have the required permissions to restore PaaS assets.
To recover point-in-time backup assets:
- On the left, click Workload > Cloud.
- Click the PaaS tab.
All the discovered PaaS assets are displayed.
- Under Recovery points type, select Provider protected.
- Click Restore in the row of the protected Azure SQL database and Azure SQL managed database asset that you want to recover.
- In the Recovery points tab, under Point in time backup, click Restore.
- Select a date and time under Restore point (UTC). You can select any restore point, between the earliest restore point, and the:
Latest backup time for online databases.
Database deletion time for deleted databases.
Microsoft Azure may round off the selected time to the nearest available recovery point, using UTC.
The default restore date and time displayed in web UI may differ based on the selected PaaS asset. For example, for Azure SQL databases, the default restore time is the current time, and for Azure SQL managed databases, the default restore time is 6 minutes earlier than the current time.
- Optionally, for Azure SQL databases, enter a name for the restored database in the Database name field. Database names cannot have special characters like < > * % & : \ / and ? or control characters. Do not end the name with a period or space. For more information about Azure resource naming rules, see https://docs.microsoft.com/en-us/azure/azure-resource-manager/management/resource-name-rules#microsoftsql
If you do not enter a name, NetBackup automatically assigns a name in the <dbName>_<Restored time in UTC> format.
To restore a database to an elastic pool within the selected target instance, select Use Elastic pool and enter the name of an existing elastic pool.
- Optionally, for Azure SQL managed databases, enter the instance name in the Managed instance field. By default, the instance name of the recovery point is displayed. You can also search for the managed instance name using the search option. You can restore to the same region to which your subscription belongs.
If you cannot see the desired managed instance in the search results, perform a manual discovery. Also, ensure that you have RBAC access to the managed instance.
- Click Next. Once the Pre-recovery check is complete, click Start recovery.
You can check the status of the job in the activity monitor.
To recover long-term retention backup assets:
- On the left, click Workloads > Cloud.
- Click the PaaS tab.
All the discovered PaaS assets are displayed.
- Click Restore in the row of the protected asset that you want to recover.
- In the Recovery points tab, under Long term retention backup, click Restore against the image that you want to restore.
- Optionally, for Azure SQL databases, enter a name for the restored database in the Database name field. Database names cannot have special characters like < > * %& : \ / and ? or control characters. Do not end the name with a period or space. For more information about Azure resource naming rules, see https://docs.microsoft.com/en-us/azure/azure-resource-manager/management/resource-name-rules#microsoftsql
If you do not enter a name, NetBackup automatically assigns a name in the restore_<dbName> format.
- Optionally, for Azure SQL managed databases, enter the instance name in the Managed instance field. By default, the instance name of the recovery point is displayed. You can also search for the managed instance name using the search option. You can restore to the same region to which your subscription belongs.
- Click Next. Once the Pre-recovery check is complete, click Start recovery.
You can check the status of the job in the activity monitor.
Note:
Tags from the portal as well as Snapshot Manager are not restored. However, the "createdby: cloudpoint" tag is created while restoring through NetBackup.
Note:
For provider-protected recovery jobs, any intermittent failures keep the recovery job running until the next schedule job cleanup runs.