You can run a full backup operation to back up SQL databases on an Azure cloud.
Limitations
By default, the Commvault Cloud software skips backing up Azure SQL databases with sizes larger than 2 TB. This limitation arises because very large databases have a high rate of failure due to Azure's limitations, especially when the data export operation to the Azure cloud exceeds 20 hours. For more information, see Export to a BACPAC file - Azure SQL Database and Azure SQL Managed Instance.
To override this default behavior, enter the maximum size of the Azure SQL database (in GB) that can be protected, in the nAzureSQLDBMaxSizeForExportInGB setting, for the applicable access node. For more information on configuring settings, see Adding a Setting for Servers. The backup jobs do not include any database with a size larger than this threshold.
Before You Begin
By default, you can use the staging path export method for exporting the database. This option has the following benefits:
-
You can export an Azure SQL database even if its BACPAC file is larger than 200 GB.
-
Protecting Azure SQL instances that have private endpoint connections or public network access disabled will fail with the storage connection string export method, since Microsoft has a limitation of exporting databases to storage accounts behind a firewall. The staging path export method does not have this limitation.
For more information about the staging path export method, see Using the Staging Path Export Method for a Secure Transfer of Data.
Procedure
-
From the navigation pane, go to Protect > Databases.
The Overview page appears.
-
On the Instances tab, in the row for the instance that you want to back up, click the action button
, and then click Backup.
The Backup options dialog box appears.
-
Under Backup level, select Full.
-
Click Submit.