Objective:
Restoring the database from Azure URL requires the below parameters.
RESTORE DATABASE [DBNAME] FROM URL = N'https://AzureStorageAccountName.blob.core.windows.net/BlobContainerName/DBNAME.bak' WITH FILE = 1,
CREDENTIAL = 'BackupAzureCredential',
MOVE N'DBNAME_PrimaryData' TO N'V:\User-Data\DBNAME.mdf',
MOVE N'DBNAME_Log' TO N'U:\User-Logs\DBNAME_log.ldf', NOUNLOAD, STATS = 5
