'How to connect database to data files in Azure Blob?

This resource states that a Azure SQL database may be attached to a database by using the following command:

WITH IDENTITY='SHARED ACCESS SIGNATURE',  
SECRET = '<your SAS key>'  
  
CREATE DATABASE testdb   
ON  
( NAME = testdb_dat,  
    FILENAME = 'https://testdb.blob.core.windows.net/data/TestData.mdf' )  
 LOG ON  
( NAME = testdb_log,  
    FILENAME =  'https://testdb.blob.core.windows.net/data/TestLog.ldf')

This results in Syntax Error near "ON". What is the issue here?

sql-serverdatabaseazure-sql-database


Solution 1:[1]

To connect Azure SQL Database to Azure blob storage, you need to create an external data source with the database scoped credentials.

CREATE DATABASE SCOPED CREDENTIAL BlobCred
WITH
IDENTITY = 'SHARED ACCESS SIGNATURE',
SECRET = 'SAS token' ;

CREATE EXTERNAL DATA SOURCE BlobStg
WITH
 ( LOCATION =‘https://storagename.blob.core.windows.net’,
CREDENTIAL = BlobCred,
TYPE = BLOB_STORAGE
) ;

Refer to official documents this & this for more details.

Sources

This article follows the attribution requirements of Stack Overflow and is licensed under CC BY-SA 3.0.

Source: Stack Overflow

Solution Source
Solution 1 NiharikaMoola-MT

Related Questions