Not able to Create Database or Restore Database on the Azure SQL Managed Instance

by Charan kumar   Last Updated September 17, 2018 15:06 PM

I am trying to restore database on the Azure SQL Managed Instance using Azure blob container URL.

Reference

https://docs.microsoft.com/en-us/azure/sql-database/sql-database-managed-instance-get-started-restore

CREATE CREDENTIAL [https://zzdevbackup.blob.core.windows.net/dbbackup] WITH IDENTITY = 'SHARED ACCESS SIGNATURE' , SECRET = 'sv=2017-11-09&ss=b&srt=sco&sp=rwdlacg=XzzcvDrhcmdldnfQ9Opu4M4Kqq1MT3tsxOADiRCQBf%2BXo%3D'

RESTORE FILELISTONLY FROM URL = 'https://zzdevbackup.blob.core.windows.net/dbbackup/Azure_Data_Sync_Test.bak'

RESTORE DATABASE [Azure_Data_Sync_Test] FROM URL = 'https://zzdevbackup.blob.core.windows.net/dbbackup/Azure_Data_Sync_Test.bak'

I am getting the below error “Msg 3201, Level 16, State 2, Line 7 Cannot open backup device ‘https://ZZZdevbackup.blob.core.windows.net/dbbackup/Azure_Data_Test.bak’. Operating system error 2(The system cannot find the file specified.).”

Please help me to figure out this issue

Thanks, Charan

Tags : azure


Related Questions


Add Active Directory User For Azure-SQL-DB

Updated February 25, 2017 13:06 PM