When restoring the database from a cloud URL there is a chance you will encounter the below error.
Msg 3271, Level 16, State 1, Line 1
A nonrecoverable I/O error occurred on file “https://ebsclouddbstore.blob.core.windows.net/mssqlbakups/madworks_backup_2015_01_13_134617.bak:” Backup to URL received an exception from the remote endpoint. Exception Message: Error occurred while referencing Blob in remote storage.
Msg 3013, Level 16, State 1, Line 1
RESTORE DATABASE is terminating abnormally.
In this case the most common reason is the backup file doesn’t exists on the Cloud storage , check the path is correct , check if the file exists on the blob storage account.