Blog Post

Azure Database Support Blog
1 MIN READ

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

Jose_Manuel_Jurado's avatar
Jan 28, 2023

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#database-backup-and-restore-with-customer-managed-tde
https://techcommunity.microsoft.com/t5/azure-sql/take-a-copy-only-backup-of-tde-protected-database-on-azure-sql/ba-p/643407

 
 
Enjoy!
Updated Feb 10, 2023
Version 3.0
No CommentsBe the first to comment