Not able to restore a database with multiple backup files from Azure blob storage (block blobs)
I found the reason why I was not able to get the list from the backup files. Since I used Ola Hallengren's script to run my backup the files were saved in a sub folder with Instance_name&gt;Database_name&gt;FULL&gt;Backupfile_name. I supposed to provide the actual backup path of the backup file by going into the properties of the backup file and then copy the path from there. Instead I was just copying the container path and then adding the backup file at the end.
It looked something like below.
https://storagesqlbackups.blob.core.windows.net/fullsqlbackup/dev-sql-01/Test_DB/FULL/dev-sql-01_Test_DB_FULL_20200821_220001.bak