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.
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.
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.
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.
You will now need to highlight the relevant files and right click them to download the files.
You now need to navigate to the SQL Server you want to restore the database on.
Right click the ‘Databases’ section and select ‘Restore Database’ and select ‘Device’ then the ‘…’ to browse for the relevant location.
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.
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.
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.