Restore DB from URL

 RESTORE DATABASE kk_NO FROM URL = 'https://blobbbb.blob.core.windows.net/sqlbackup1/db/20191129/full_20191129_120001.bak'  

with

NORECOVERY 

,REPLACE 

, MAXTRANSFERSIZE = 4194304, BLOCKSIZE = 65536, BUFFERCOUNT = 2000

,STATS = 10;

 

GO

 

RESTORE DATABASE kk_NO FROM URL = 'https://blobbb.blob.core.windows.net/sqlbackup1/db/20191204/diff_20191204_91502.bak'

 

--With MOVE 'kk_SE' to 'F:\Data\kk_SE_clone.mdf',

--MOVE 'kk_log_SE' to 'h:\Log\kk_log_SE_clone.ldf',

with

RECOVERY 

,REPLACE 

, MAXTRANSFERSIZE = 4194304, BLOCKSIZE = 65536, BUFFERCOUNT = 2000

,STATS = 10;

 

GO