Azure blob storage for SQL server

SQL Server 2016 Database files in Azure Blob storage

by

Azure blob storage is very cheap we all know that. Check the pricing here. SQL Server database files can be placed Azure blob storage which has the following advantages. 

  • Multiple copies of the files 
  • Can access from anywhere by attach the files. 
  • Less expensive storage 

Here is the steps how we can configure it. 

Step 1: Create a blob storage in Azure portal 

Step 2: Open Azure storage explorer and create the SAS key 

Step 3: Open the SSMS and start a new query. 

create-database-sql

 

You can explore the files in Azure blob explorer and see the ldf and mdf file. 

 

 

Leave a Comment