Restore Database to Microsoft Azure Blog

Kailash Chandra Behera | Saturday, June 13, 2020

Introduction

In my previous blog, we discussed how to backup database from Microsoft Azure blog storage. Here we will discuss the step by step process to restore database to Microsoft Azure Blog.

Getting Started

Let's say we have 'TestDB' database which will be restored to the Microsoft Azure storage container( https://mystorage.blob.core.windows.net/myTestcontainer) from a backup located at 'D:\' drive. The SQL Server credential for the Azure container has already been created.

Let's say a SQL Server credential for the destination container must already exist as it cannot be created through the Restore task. The 'TestDB' database does not currently exist on the server.

  1. Open SQL Server Management Studio, connect to an instance of the SQL Server Database Engine.

  2. In Object Explorer, expand that instance.

  3. Right-click Databases and select Restore Database....

  4. On the General page, select Device under the Source section.

  5. Click the browse button to open the Select backup devices dialog box.

  6. Select File from the Backup media type: drop-down list.

  7. Click Add and the Locate Backup File dialog box opens.

  8. Navigate to 'D:\', select the backup file and then click OK.

  9. Click OK to return to the General page.

  10. Click Files in the Select a page pane.

  11. Check the box Relocate all files to folder.

  12. Enter the container, https://mystorage.blob.core.windows.net/myTestcontainer, in the text boxes for Data file folder and Log file folder.

  13. Click OK.

Related Articles

  1. Backup SQL Database to the Azure Blob
  2. Backup SQL Database Using SSMS
  3. Enable SQL Remote Connection
  4. Encrypt data across communication channels
  5. Recovery Database From Warm-Standy Mode
  6. Create SQL Job in SQL Server 2017“

Summary

In the above, we discussed the step by step process how to Restore Database to Microsoft Azure Blog, I hope you have enjoyed it.

Thanks