我正在使用以下命令(更改了 blobname 和数据库名称)尝试从 2014 年数据库的备份还原到 Azure SQL Server 数据库
我正在使用我的 MSDN 积分在澳大利亚东南部
我尝试过使用 SQL Server 2016 Management Studio 和 2017 Management Studio
RESTORE DATABASE originaldatbasename
FROM URL = 'https://longblobname.bak’
WITH CREDENTIAL = 'mycredental';
, STATS = 5
我收到错误
Unclosed quotation mark after the character string
'https://longblobname.bak’
WITH CREDENTIAL = mycredental;
, STATS = 5
'.
Msg 102, Level 15, State 1, Line 2
Incorrect syntax near 'https://longblobname'.
答案1
bak 后面的字符不是单引号(位于双引号键上)。
RESTORE DATABASE originaldatbasename
FROM URL = 'https://longblobname.bak'
WITH CREDENTIAL = 'mycredental', STATS = 5 ;