This browser is no longer supported.
Upgrade to Microsoft Edge to take advantage of the latest features, security updates, and technical support.
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(278.4, 21%, 36%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EJF%3C/text%3E%3C/svg%3E)
I'm trying to write a powershell script to export a database to a a BACPAC from a server with Private Link configured (no public access) using the latest version of the Az module (4.8.0). I'm having a hard time understanding what parameter values I should be passing in based on teh documentation. Here is my current code:
$exportRequest = New-AzSqlDatabaseExport
-ResourceGroupName $resourceGroupName
-ServerName $databaseServerName
-DatabaseName $db
-StorageKeytype $StorageKeytype
-StorageKey $storageKeyType
-StorageUri $BacpacUri
-AdministratorLogin $databaseAdminUserName
-AdministratorLoginPassword $adminPassword `
-UseNetworkIsolation $true
-SqlServerResourceIdForPrivateLink "/subscriptions/xxxxxxxx-xxxxx-xxxx-xxxx-xxxxxxxxxxxxx/resourceGroups/mdp-replicated-source-data-prod-rg/providers/Microsoft.Sql/servers/mdp-replicated-data-sql-prod-01"
The error message I'm getting is
New-AzSqlDatabaseExport : The specified resource 'https://management.centralus.control.database.windows.net/modules/AzureResourceManager/subscriptions/xxxxxxxx-xxxxx-xxxx-xxxx-xxxxxxxxxxxxx/resourceGroups/mdp-replicated-source-data-prod-rg/providers/Microsoft.Sql/servers/mdp-replicated-data-sql-p
rod-01/databases/[dbname]/export?api-version=2020-02-02-preview' was not found.
Does anyone have any good working examples of how to export a database from a server with Private Link using the latest verison of the Az modules?
UPDATE: I also tried to export this database to the same storage account via the Azure portal, and got a connectivity error to the database, so perhaps I don't have the right endpoints created to do the export operation? I'm having a hard time finding any documentation that helps describe what is required to export a database with Azure Private Link configured
UPDATE 2: If I re-enable the public endpoint (via the portal) and then request an export (via the portal) it works successfully. Do we need to enable public endpoint to do the export?
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(25.6, 10%, 12%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EKM%3C/text%3E%3C/svg%3E)
@Josh Fennessy To access the database, the machine you are running this script from, needs to be the same VNET as the private endpoint.
If it is on a different VNET, can you connect both VNETs via peering?
I am running this command from a machine in a peered VNET. I can connect to the database from SSMS. From the same machine I cannot however create and new database export either from PowerShell or the Portal
what about the storage account? is that on a peered VNet too?
The storage account is not in the VNET right now and did still have public endpoint enabled but does have a private endpoint connection to the sql server.
When you have the Private Endpoint and no Public Endpoint for your database, the request must come from within the Virtual Network or a connected Network. Requests from the portal will not work.
You will need to run these commands from a VM inside the Virtual Network, or temporarily enable the public endpoint in order for this to be successful.
We are running these commands (and accessing portal) via a machine within the virtual network. I am able to connect to the database using SSMS from that same machine, but not connect via the PowerShell cmdlets.