无法在Azure SQL托管实例上创建数据库或还原数据库 [英] Not able to Create Database or Restore Database on the Azure SQL Managed Instance

问题描述

我正在尝试使用Azure blob容器URL在Azure SQL托管实例上还原数据库.

参考

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

创建具有身份=共享访问签名"，秘密="sv = 2017-11-09& ss = b& srt = sco& sp = rwdlacg"的凭据[https://zzdevbackup.blob.core.windows.net/dbbackup] = XzzcvDrhcmdldnfQ9Opu4M4Kqq1MT3tsxOADiRCQBf％2BXo％3D'

从URL还原文件列表='https://zzdevbackup.blob.core.windows.net/dbbackup/Azure_Data_Sync_Test.bak'

从URL还原数据库[Azure_Data_Sync_Test] ='https://zzdevbackup.blob.core.windows.net/dbbackup/Azure_Data_Sync_Test.bak'

我收到以下错误消息:消息3201，级别16，状态2，第7行，无法打开备份设备'https://ZZZdevbackup.blob.core.windows.net/dbbackup/Azure_Data_Test.bak".操作系统错误2(系统找不到指定的文件.).

请帮我弄清楚这个问题

谢谢，Charan

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

推荐答案

我遇到了同样的问题，尝试两件事:

I had the same issue, try two things :

1.不要忘记从SAS密钥中删除前导?.

1. From the SAS key don't forget to remove the leading ?.

2.设置到期日期/时间，例如开始日期:15/09/2018，结束日期:15/10/2018

2. Set the expiry date/time, e.g Start Date: 15/09/2018, End Date: 15/10/2018

这篇关于无法在Azure SQL托管实例上创建数据库或还原数据库的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！