Lesson Learned #311:Error-1117 the request could not be performed because of an I/O device error

Posted by

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

Our customer got the following error message performing a backup very large database to a blog storage - Error-1117 the request could not be performed because of an I/O device error.


In this situation, you may reach this error depending on the size of the blob storage, in this situation, please, run the backup in stripping backup format "Azure Blob Storage block blobs have 200GB size limitation. If your database is bigger than 200GB, you should use stripped backup by providing several URL locations where parts of the backup will be placed" Native database backup in Azure SQL Managed Instance | Microsoft Learn


Also, remember at the moment of the restore if you have your own BYOK that you might have asymmetric key with thumbprint error. Please go through links which will help you how to do it.


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.