Restore from Azure Storage DB to sqlserver 2014
0
votes
1
answer
174
views
I am trying to restore the Database from Azure Storage to Sql server 2014 but getting the error
"TITLE: Microsoft SQL Server Management Studio
------------------------------
An exception occurred while executing a Transact-SQL statement or batch. (Microsoft.SqlServer.ConnectionInfo)
------------------------------
ADDITIONAL INFORMATION:
A nonrecoverable I/O error occurred on file "https://*****.blob.core.windows.net/sql_backup/Test_DB.bak :" The specified URL points to a Block Blob. Backup and Restore operations on Block Blobs are not permitted..
RESTORE HEADERONLY is terminating abnormally. (Microsoft SQL Server, Error: 3271).
I am restoring the DV using SSMS from URL option
Any suggestions please ?

Asked by Saira
(101 rep)
Aug 11, 2022, 03:29 AM
Last activity: Aug 11, 2022, 03:57 AM
Last activity: Aug 11, 2022, 03:57 AM