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.
According the error message posted in the comments this is a faulty disk that cannot serve write requests (at a certain location).