To export an Azure SQL database with a BACPAC file larger than 200 GB, use a staging path with Microsoft SQL Server Data-Tier Application Framework (DacFx).
By default, you can export an Azure SQL database to blob storage with the maximum BACPAC file size of 200 GB.
Note
Active Directory authentication does not work for Azure SQL databases that are exported and imported through staging with Microsoft SQL Server Data-Tier Application Framework (DacFx).
Procedure
-
From the navigation pane, go to Protect > Databases.
The Instances page appears.
-
Click the instance.
The instance page appears.
-
On the Configuration tab, in the SQL cloud configuration section, click Edit.
The SQL cloud configuration dialog box appears.
-
Move the Use staging path for import/export toggle key to the right.
-
In the Staging path used for import/export box, enter the staging path that is available on all the configured access nodes.
Note
If you leave the staging path empty, the Commvault software considers the job results directory as default staging location.
-
From the SQL server authentication list, select the credentials of an Azure Server admin account.
By default, this account is the instance server admin account that has access to the instance and database to perform all operations, including backup, restore, and browse operations.
-
Click Save.