Select Page

Restore SQL Backup Using Microsoft Azure Storage Explorer

Initially you will need to install the Microsoft Azure Storage Explorer or Login to a server that has this installed. You can download the product from here. You’ll need to follow the install wizard that runs when double clicking on the .exe file.

When you have logged in to the machine that has the product installed you will need to open Microsoft Azure Storage Explorer.

Microsoft Server Logged In - Restore SQL Backup Using Microsoft Azure Storage Explorer

You will need to login using either your Azure account details or the Azure Connection String that you can find in the Storage Explorer on the Azure Console.

Microsoft Azure Storage Explorer - Restore SQL Backup Using Microsoft Azure Storage Explorer

When logged in you will need to select the relevant Storage Account that you have configured. Then you will need to select the correct Blob Container. You will now see a list of the relevant database backups.

Microsoft Azure Storage Explorer Database Backup Query - Restore SQL Backup Using Microsoft Azure Storage Explorer

You will now need to find the relevant .BAK file for the time that you are trying to restore the database. You can replay the log files in to the database if there isn’t a full backup for the exact date you require.

Microsoft Azure Storage Explorer Database Backup Query BAK - Restore SQL Backup Using Microsoft Azure Storage Explorer

You will now need to highlight the relevant files and right click them to download the files.

Microsoft Azure Storage Explorer Database Highlighted - Restore SQL Backup Using Microsoft Azure Storage Explorer

You now need to navigate to the SQL Server you want to restore the database on.

SQL Server Logged In - Restore SQL Backup Using Microsoft Azure Storage Explorer

Right click the ‘Databases’ section and select ‘Restore Database’ and select ‘Device’ then the ‘…’ to browse for the relevant location.

SQL Restore Database - Restore SQL Backup Using Microsoft Azure Storage Explorer

Browse to the location of the files that were downloaded. Make sure to add all of the Log files if you want the database to be restored to a certain point in time.

SQL Select Backup Devices - Restore SQL Backup Using Microsoft Azure Storage Explorer

You will now see the files ready to be restored. If you need to change the Database name you should type this in the ‘Database’ section under the Destination.

SQL Restore Database BAK LOG - Restore SQL Backup Using Microsoft Azure Storage Explorer

Click OK to proceed with the restore. This will now complete the restore process and you will have the database at the required point in time.

SQL Restore Database Successful - Restore SQL Backup Using Microsoft Azure Storage Explorer

Pin It on Pinterest

Share This