Im 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:

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.

Did I miss some prerequisites with premium storage?

Hi,

Please check if there are Event 153 errors in Windows Event logs.

Also, confirm the size of the database file. It is not recommended to store SQL Databases bigger than 10Gb in the c:\ . drive. Any DB over 10GB in size should go on Data Disks.

Also, you may try to resize the VM once temporary and resize back if needed. This will move the VM to a different node, so that we can check if it related to Hardware issue.

Regards,

Manu

I think you didn't get my point, i try to create a new Database directly into a container (not in a disk). It work fine with Standard-GRS container, but doesn't work on Premium-LRS container.

Regards,

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.

• Proposed as answer by Pradnya KhadapkarMicrosoft employee 7 hours 37 minutes ago

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.

• Proposed as answer by Pradnya KhadapkarMicrosoft employee Thursday, April 30, 2015 11:39 PM
• Marked as answer by Manu RekharMicrosoft contingent staff, Moderator 4 hours 4 minutes ago

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.

• Proposed as answer by Pradnya KhadapkarMicrosoft employee Thursday, April 30, 2015 11:39 PM
• Marked as answer by Manu RekharMicrosoft contingent staff, Moderator Saturday, May 02, 2015 3:12 AM

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.

• Proposed as answer by Pradnya KhadapkarMicrosoft employee Thursday, April 30, 2015 11:39 PM
• Marked as answer by Manu RekharMicrosoft contingent staff, Moderator Saturday, May 02, 2015 3:12 AM