Azure-docs: Azure SQL Database - Restore Database Is Not Supported in this Version of SQL

[GHoh]

Attempts to restore a .bak file stored in Blob Storage to an Azure SQL Managed Instance fails.

This database exists in an Elastic Pool. When creating the pool and database, we thought we were creating a Azure SQL Managed Instance. There are posts that state that databases in an ElasticPool are not managed instances. Could this be why restore datbase fails?

T-SQL
RESTORE DATABASE [Web] FROM URL = 'somestorage.blob.core.windows.net/backups/…' WITH CREDENTIAL = 'SHARED ACCESS SIGNATURE'

Error
'RESTORE DATABASE' is not supported in this version of SQL Server.

I confirmed that the master key as well as the scoped credential were created successfully.
I confirmed that the URL is correct.
Can you recommend a solution to resolve this problem?

We initially encountered a problem where creation of the credential failed following the demo on Microsoft.com. CHEEKATLAPRADEEP responded that the correct syntax is CREATE DATABASE SCOPED CREDENTIAL and not CREATE CREDENTIAL as shown in the demo. Hopefully this fix for the restore is also an update to the syntax.

Thank you in advance.

Document Details
⚠ Do not edit this section. It is required for docs.microsoft.com ➟ GitHub issue linking.
ID: 759e5bd8-e4f0-24aa-ab48-c2820fccd39a
Version Independent ID: b42082b1-8c3e-82d0-d6ea-ecd57be1cdba
Content: Restore a backup to Azure SQL Database Managed Instance
Content Source: articles/sql-database/sql-database-managed-instance-get-started-restore.md
Service: sql-database
GitHub Login: @srdan-bozovic-msft
Microsoft Alias: srbozovi

[mike-urnun-msft]

Hello @GHoh Thank you for your feedback! This channel is for driving improvements towards MS Docs. In order to best address your question with the right team, could you provide us with the URL of the MS Doc that you were following, if any?

[GHoh]

@mike-urnun-msft Thank you for reviewing. I'm following the Quickstart: Restore a database backup to an Azure SQL Database Managed Instance.

[Mike-Ubezzi-MSFT]

@GHoh This is unsupported. You cannot restore a .bak file in the manner in which you are attempting to execute the restore. You CAN restore a .bacpac file. Please see the following Stack Overflow forum post for additional options: Restoring SQL Server backup to Azure SQL Database.