Standard

Posted by

Posted on

October 27, 2017

Posted under

Azure

Comments

Leave a comment

Backup On-Premise SQL Server Database to Microsoft Azure

Blog36_1

-> Creating a Storage Account,

Blog36_2.PNG

Blog36_3.PNG

-> Once the Storage account is deployed. Click on Blog36_4 Resources and then click on your Storage that we deployed just now. It is jbsqlbackups in my case,

Blog36_5.PNG

-> Click on Containers and add a new container.

Blog36_6.PNG

-> Click on Access Keys and track down your Storage Account Name and the Keys,

Blog36_7.PNG

-> Open SQL Server Management Studio and try a backup,

Blog36_8.PNG

Blog36_9.PNG

Blog36_10.PNG

Blog36_11.PNG

Blog36_12.PNG

-> Lets connect to the Azure storage and check the backup file,

Blog36_13.PNG

-> Copy the Access key that was noted earlier and paste it connect to the Azure Storage,

 

Blog36_14

Blog36_15.PNG

-> Lets try restoring the database,

Blog36_16

Blog36_17.PNG

-> Click on OK and you will get the below screen. Select the backup that you ant to restore,

Blog36_18.PNG

Blog36_19.PNG

Blog36_20.PNG

-> The database is restored and ready for use.

Thank You,
Vivek Janakiraman

Disclaimer:
The views expressed on this blog are mine alone and do not reflect the views of my company or anyone else. All postings on this blog are provided “AS IS” with no warranties, and confers no rights.

Leave a Reply