Azure高级存储和SQL Server文件

I’m actually trying to use a Premium Storage to store SQL files like I usually do with classic storage: • Generate a Shared Access Signature on Azure Storage Explorer • Create credential on SQL server • Run some script like:

我实际上尝试使用高级存储来存储SQL文件,就像我通常使用经典存储一样:•在Azure存储资源管理器上生成共享访问签名•在SQL服务器上创建凭据•运行一些脚本,如:

CREATE DATABASE HammerCont  
ON 
(NAME = HammerCont, 
   FILENAME = 'https://scopitpremiu.blob.core.windows.net/bdd/HammerCont.mdf') 
 LOG ON 
(NAME = HammerCont_log, 
    FILENAME = 'https://scopitpremiu.blob.core.windows.net/bdd/HammerCont.ldf') 

But if it work fine with Standard-GRS storage, I still have this message « CREATE FILE encountered operating system error 1117(The request could not be performed because of an I/O device error.) while attempting to open or create the physical file 'https://scopitpremiu.blob.core.windows.net/bdd/HammerCont.mdf'. » on Premium-LRS storage.

但是,如果它与Standard-GRS存储一起正常工作,我仍然有这个消息«CREATE FILE遇到操作系统错误1117(由于I / O设备错误而无法执行请求。),同时尝试打开或创建物理文件'https://scopitpremiu.blob.core.windows.net/bdd/HammerCont.mdf'。 »在Premium-LRS存储上。

Did I miss some prerequisites with premium storage?

我是否错过了高级存储的一些先决条件?

1 个解决方案

#1

This is currently not supported in SQL Server. SQL Server will be releasing a hotfix in June to add support for creating data files on Azure Premium Storage.

SQL Server目前不支持此功能。 SQL Server将在6月发布一个修补程序,以添加对Azure Premium Storage上创建数据文件的支持。