Mar 25 2020 02:53 AM
Hi.
I am trying to restore database from my azure blobs to SQL Server deployed in my local machine, but i get an error.
In SSMS (or via sqlcmd.exe) i trying to execute
USE [master] RESTORE FILELISTONLY FROM URL = N'https://<myazureblobaccount>/<myblobcontainer>/mybackup.bak'
but it failed with error
Msg 3201, Level 16, State 2, Line 1
Cannot open backup device 'https://<myazureblobaccount>/<myblobcontainer>/mybackup.bak'. Operating system error 86(The specified network password is not correct).
Msg 3013, Level 16, State 1, Line 1
RESTORE FILELIST is terminating abnormally.
Then i tryed to exceute with credentials option
USE [master] RESTORE FILELISTONLY FROM URL = N'https://<myazureblobaccount>/<myblobcontainer>/mybackup.bak'
WITH CREDENTIAL = 'test_cred'
but it still error
Msg 3271, Level 16, State 1, Line 1
A nonrecoverable I/O error occurred on file "https://<myazureblobaccount>/<myblobcontainer>/mybackup.bak:" The specified URL points to a Block Blob. Backup and Restore operations on Block Blobs are not supported when WITH CREDENTIAL syntax is used..
Msg 3013, Level 16, State 1, Line 1
RESTORE FILELIST is terminating abnormally.
What am i doing wrong? Help me please. Thank you.