Restore of 100Gb database fail

[nb45]

Hi;
When i try to restore with Veritas BackupExec 9.1 the sql database after 1hr and 30 minutes, we see the following error in the SQL Errorlog:

2006-09-24 13:37:08.19 spid54 BackupMedium::ReportIoError: read failure on backup device 'AF_00__a951399e_0cc9_44cf_b7d5_5eb2c78ac536_'. Operating system error 995(The I/O operation has been aborted because of either a thread exit or an application request.).
2006-09-24 13:37:08.19 spid54 Internal I/O request 0x7EC23810: Op: Read, pBuffer: 0x18BA0400, Size: 512, Position: 7680, UMS: Internal: 0x0, InternalHigh: 0x0, Offset: 0x0, OffsetHigh: 0x0, m_buf: 0x00000000, m_len: 0, m_actualBytes: 0, m_errcode: 995, BackupFile: AF_00__a951399e_0cc9_44cf_b7d5_5eb2c78ac536_

Over the Enterprise manager, we see the SPID of the restore with the waiting type NETWORKIO.

How i can fixed this behavior?. Whit small database the restore process working fine.

 

[mrdenny]

I'd start with a checkdisk and make sure that the disk is healthy.

Also do a checkdisk on the drive with the backup on it. Sounds like the backup is either broken or the drive is hosed.

Denny
MCSA (2003) / MCDBA (SQL 2000) / MCTS (SQL 2005) / MCITP Database Administrator (SQL 2005)

--Anything is possible. All it takes is a little research. (Me)

http://www.mrdenny.com