Azure SQL托管实例不支持RESTORE DATABASE消息 [英] RESTORE DATABASE is not supported message for Azure SQL Managed Instance
问题描述
尝试在Azure SQL数据库托管实例上还原.bak文件时出现以下错误
I am getting the below error when trying to RESTORE a .bak file on an Azure SQL Database Managed Instance
'RESTORE DATABASE'.
我正在尝试使用sqlcmd CLI运行此命令
从磁盘还原数据库MASS_2 = N'./MASS_SIM.bak'，文件= 1，NOUNLOAD，REPLACE，NORECOVERY，STATS = 5
RESTORE DATABASE MASS_2 FROM DISK = N'./MASS_SIM.bak' WITH FILE = 1, NOUNLOAD, REPLACE, NORECOVERY, STATS = 5
推荐答案
你好，
请创建一个安全凭据以访问Blob存储.
Hello,
Please create a security credential to access a blob storage.
CREATE CREDENTIAL [https://MYSTORAGEACCOUNTNAME.blob.core.windows.net/MYCONTAINERNAME]
SECRET = 'MYBIGLONGKEYSTRINGFROMTHEAZUREPORTAL';
The portions you have to change in there are:
•MYBIGLONGKEYSTRINGFROMTHEAZUREPORTAL
RESTORE DATABASE MYDATABASENAME
The portions you have to change:
Hope this helps.
Regards,
Alberto Morillo
SQLCoffee.com
这篇关于Azure SQL托管实例不支持RESTORE DATABASE消息的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！
