This article is contributed. See the original author and article here.
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
Brought to you by Dr. Ware, Microsoft Office 365 Silver Partner, Charleston SC.
Recent Comments