Friday, 21 December 2018

Restore Database From URL with Credential


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

No comments:

Post a Comment