Lesson Learned #318: Using Archive Access Tier in a blob storage

This post has been republished via RSS; it originally appeared at: Microsoft Tech Community - Latest Blogs - .

In case that you are using Archive Access Tier restoring a backup in Azure SQL Managed Instance or using Bulk Insert in Azure SQL Database you need to know that, currently, it is not supported. 

 

For example, using Restore Database TSQL in Azure SQL Managed Instance you might have the following error message: Msg 3203, Level 16, State 1, Line 8 - Read on "https://myblob.blob.core.windows.net/backups/backup.bak" failed: 13(The data is invalid.) - Msg 3013, Level 16, State 1, Line 8 - RESTORE DATABASE is terminating abnormally or using bulk insert you might have other error message like: Reading the file  Msg 4823, Level 16, State 1, Line 18 -  Cannot bulk load. Invalid column number in the format/reading file "File.txt".

 

Enjoy!

Leave a Reply

Your email address will not be published. Required fields are marked *

*

This site uses Akismet to reduce spam. Learn how your comment data is processed.