Sample Header Ad - 728x90

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 SSMS_Restore_From_ Any suggestions please ?
Asked by Saira (101 rep)
Aug 11, 2022, 03:29 AM
Last activity: Aug 11, 2022, 03:57 AM