I am currently fighting an issue in which I'm looking for confirmation that this could be related to a bad backup or not.
I have attempting to restore two seperate full backs for the same database.
What I am seeing is the following error during the process in the sql logs:
SQL Server has encountered 1 occurrence(s) of I/O requests taking longer than 15 seconds to complete on file [I:\database_name.mdf] in database [<Database name is not available>] (5). The OS file handle is 0x00000000000007EC. The offset of the latest long I/O is: 0x00001adda30000
Then the process a little later fails with:
Msg 3202, Level 16, State 1, Line 1
Write on "???" failed: 1117(The request could not be performed because of an I/O device error.)
Msg 3013, Level 16, State 1, Line 1
RESTORE DATABASE is terminating abnormally.
The system is virtual. One thing we have attempted to do is to remove the vdmk and recreated it in the same datastore and lun on the san within a share raid group.
Backups are being performed by the standard backup maintenance plan. Compression is enabled and verfiy backup integrity is enabled.
The server is running OS Windows Server 2008 R2 and SQL Server 2008 R2 SP1.
I believe this is being cause due to an I/O issue with the disk subsystem. However, could this be cause due to a bad backup?