"The request could not be performed because of an I/O device error"
Published 10 May 2023
2023-04-01 21:47:37.781 +01:00 [ERR] CreateImageRequestEvent (image name: "[image name]") Operation 50286 failed with general exception
System.Exception: Microsoft.Data.SqlClient.SqlError: Write on "???" failed: 1117(The request could not be performed because of an I/O device error.)
Microsoft.Data.SqlClient.SqlError: RESTORE DATABASE is terminating abnormally.
If the file share is an Azure file share, then it has a maximum file size of 4 TiB and it is impossible for SQL Clone to store an image there that is larger than 4 TiB on disk. When creating an image that exceeds this limit, you will get the above error.
There are some options to address this -
- Use a file share that doesn't have this restriction. For example, by creating a virtual machine in Azure with a large enough disk, then manually setting up an SMB share.
- Reduce the size of the image. This could be by manually removing data that is not required, or by using a dedicated subsetting tool.