locked
Azure premium Storage and SQL Server Files RRS feed

  • Question

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

    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?

    Tuesday, April 28, 2015 12:35 PM

Answers

  • 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.
    Thursday, April 30, 2015 11:39 PM

All replies

  • 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

    Tuesday, April 28, 2015 8:34 PM
  • 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,

    Wednesday, April 29, 2015 12:32 PM
  • 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.
    Thursday, April 30, 2015 11:39 PM