How to solve error "Can not perform requested operation on nested resource. Parent resource not found" az sql db import throws

user_1005609 0
Viewed 7735

As part of my Azure Devops release pipeline I want to restore the bacpac of the previous days data from Azure storage.

I am running the following az command

az sql db import -s myprod.database.windows.net -n mydb
-g myresourcegroup -p "${mypassword}" -u myuser
--storage-key "${mystoragekey}" --storage-key-type StorageAccessKey 
--storage-uri 
"https://mystore.blob.core.windows.net/db/bk$(date -d "yesterday" '+%Y-%m-%d').bacpac"

This command fails with the following ERROR: Can not perform requested operation on nested resource. Parent resource 'myprod.database.windows.net/mydb' not found.

The db already exists on the server. Is this saying that the parent in this case is the server or the db? It should be able to find both

bacpac devops azure-devops azure sql-server
1 Answers

.database.windows.net should not be there. myprod.database.windows.net is the server's fully qualified DNS name, but in the API the server's "name" is just myprod.

Hope this helps.

user_81884330
Related