Moreover, of course, I included the name of my Azure Storage account. See the below screenshot for more information on how I did it.Īs you can see, in order to define the credential object, I used in the “SECRET” clause, the key provided in my Azure Storage account. We need to create a credential object, that will be allowing access to the previously created azure storage and private blob container. Step 4: Create a Credential Object On-Premises (via SSMS) Great! Now let’s switch to the on-premises SQL Server instance and follow the below steps.
This container, will be used for storing the SQL Server database backup files. The next step, is to create a private blob container. Take a note of key1 or key2, since they will be used later on-premises while defining the credential to be used for accessing the Azure storage account.
The next step, is to check the access keys. We then click on the “Create” button and after a few moments, we can see that the deployment was successfully completed. As you can see in the below screenshot, validation was successful. To do this, you navigate to “Storage Accounts” and click on the “Create storage account” button.įor the purposes of this demo, the account kind was set to “StorageV2”, that is “general purpose v2”. The first step, is if you don’t have a generic Storage Account on Azure, to create one. Step 1: Create a Generic Storage Account on Azure ( Lifetime Access, Certificate of Completion and more!) Our course, will help you get started with Azure SQL Database and SQL Server on Azure Virtual Machines fast and easy. (special limited-time discount included in link). Learn more about Azure SQL Database: Enroll to our Online Course!Ĭheck our online course on Udemy titled “ Introduction to Azure SQL Database for Beginners” * To restore the database from Azure blob storage to the on-premises SQL Server instance, you just run the relevant RESTORE command.
Create a credential object that can access the storage account (step 4).Create a private blob container (step 3).If you haven’t created a generic storage account, you will need to create one (step 1).The high-level process to Backup a SQL Server Database from On-Premises to Azure blob storage is: On Azure: High-level process to Backup a SQL Server Database from On-Premises to Azure Blob Storage Moreover, we will see how we can restore a database on-premises, based on a backup file store on Azure blob storage.
AZURE STORAGE EMULATOR SQL INSTANCE HOW TO
In this article, we are going to see, how to backup a SQL Server database from on-premises to Azure blob storage. In a previous article, we discussed how you can create your first database on Azure SQL Database.