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

[Guest Jose_Manuel_Jurado]

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.

Customer-managed transparent data encryption (TDE) - Azure SQL Database & Azure SQL Managed Instance & Azure Synapse Analytics

Take a COPY_ONLY backup of TDE protected database on Azure SQL Managed Instance

 

 

 

Enjoy!

 

Continue reading...