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

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!