Azure SQL Managed Instance: RESTORE HEADERONLY is terminating abnormally. (Microsoft SQL Server, Error: 3201)
I'm trying to restore my database into Azure SQL Managed instance from blob storage URL. But I'm getting below error.
RESTORE HEADERONLY is terminating abnormally. (Microsoft SQL Server, Error: 3201)
I tried to restore it to localhost and that worked fine. Blob storage is having all the permissions.
Why is it working in localhost and not in Azure SQL managed instance.
Cannot open backup device '******' operating system error 5 (Access is denied)
This can because of it not able to access the storage account.
To access data from outside of the virtual network in Managed instance public endpoint for a managed instance helps you to achieve that. By default, it is Disabled turn it to Enable.
And also confirm that you enable public network access in storage account from all networks.
Also see,
For more information refer,
Backup and restore SQL Server to Azure Blob storage
Troubleshooting potential backup/restore issues on Azure SQL Managed Instance
- inserting data into SQL DB from C# ASP.NET
- Fastest way to determine if record exists
- Create Index without name while creating table
- Unrecognized column name that I define
- How to merge 2 or more rows and SUM a column in an UPDATE without a primary key?
- What are the advantages of running SQL Server in a Docker container?
- How do I get the MAX of two values in SQL Server?
- How can I split a single, very long string into separate columns and rows delimited by commas and semicolons in SQL Server?
- Why can't I use table names of aliased tables in WHERE clause?
- Function vs. Stored Procedure in SQL Server
- How to correctly join two tables that each have Start Date and Stop Date columns?
- How to run sql script using SQL Server Management Studio?
- SQL copying data with new foreign keys
- SQL Server truncates decimal points of a newly created field in a view
- SQL Grouping and Nested Concatenation
- How to pull width & height out of string?
- How to delete, re-create, move, import, and export LocalDB databases?
- The locale identifier (LCID) 8192 is not supported by SQL Server
- SQL Server Initial database connection timeout in 30 seconds
- Why use a READ UNCOMMITTED isolation level?
- Recursive CTE and how to overcome circular reference error
- Select min or max based on where duplicate value exists
- Converting accented characters in varchar() to XML causing "illegal XML character"
- Incorrect syntax near '1'. Expecting ID, QUOTED_ID, or '.' Error with SQL Pivot
- Update SQL table using selection from another table
- Clarification on joins
- Foreign key constraint may cause cycles or multiple cascade paths?
- pyodbc cursor.fetchall() is returning "strange" values
- T-SQL Get File Extension Name from a Column
- How to do a cross-database-query join in SQLAlchemy?