We have been experiencing an intermittent problem with the restore of a 50GB database to a SQL Server that runs under Windows 2003. The restore runs for 50 minutes or so, then dies with the following errors:
BackupMedium::ReportIoError: read failure on backup device '\\POSDBASE1\SQLBackups\Current\Autopart_Full.bak'.
Operating system error 1130(Not enough server storage is available to process this command.).
Internal I/O request 0x4372D888: Op: Read, pBuffer: 0x059D0000, Size: 65536, Position: 44023354880, UMS: Internal: 0x0, InternalHigh: 0xD197DC7C, Offset: 0x3FFF1600,
OffsetHigh: 0xA, m_buf: 0x059D0000, m_len: 65536, m_actualBytes: 0, m_errcode: 1130, BackupFile: \\POSDBASE1\SQLBackups\Current\Autopart_Full.bak
In the past, a reboot of POSDEVDB1 has cleared this up (for weeks at a time). Ive rebooted twice today and cannot get around this problem. I do not believe this is a SQL Server problem.
I can restore the SQL dump if I copy it locally. The problem seems to occur only when restoring over a newtork.
Any thoughts? Comments? Suggestions?