Hello everyone,
I'm trying to restore the database from the SQL Blob storage using following T-SQL script.
RESTORE DATABASE AdventureWorks FROM URL = 'https://mystorageaccount.blob.core.windows.net/mycontainer/AdventureWorks2012.bak'
WITH
CREDENTIAL = 'mycredential'
,NORECOVERY
--,REPLACE
,STATS = 5;
GO
However, while doing so I'm getting the following error.
"It was originally formatted with sector size 512 and is now on a device with sector size 65536"
Can anybody please advise how to get rid of this problem?
It's really urgent, any help would be much apprec