While attempting to restore a 4 TB MDF/data database with a 1.8 TB LDF/log file, I'm receiving the following error:
Write on '???' failed: 1117 (The request could not be performed because of an I/O device error.
Error: 3202, Severity: 16, State: 1
The backup appears to have created successfully on the primary machine, but will not restore to the backup machine. Both servers are running the SQL Server 2012 Enterprise Edition. The location of the .LDF transaction log file is being moved during the restore from the primary's I drive to the backups L drive, but this never posed an issue in the past.
The database is made up of 3 .MDF files: one approximately 2 TB, another at 1.4 TB, and another around 300 GB. The .LDF transaction log file is about 1.8TB. The restore locations have enough space, with the drive for the .mdf files having 6 TB total and the drive for .ldf having 2 TB total.
Any thoughts would be greatly appreciated.
FYI: This article is also posted in StackOverflow at:
https://stackoverflow.com/questions/27116806/sql-server-restore-error-3202
I'm uncertain which location is best for this type of question.
Best Answer
According the error message posted in the comments this is a faulty disk that cannot serve write requests (at a certain location).