Lesson Learned #311:Error-1117 the request could not be performed because of an I/O device error
Published Jan 28 2023 09:20 AM 5,427 Views

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.
https://docs.microsoft.com/en-us/azure/azure-sql/database/transparent-data-encryption-byok-overview#...
https://techcommunity.microsoft.com/t5/azure-sql/take-a-copy-only-backup-of-tde-protected-database-o...

 
 
Enjoy!
Version history
Last update:
‎Feb 10 2023 12:53 AM
Updated by: