June 29, 2004 at 9:17 am
I'm having errors backing up one specific database on the shared drive. I can backup the database on the local drive but when i try backing up the database on a network drive(SAN) i see the errors below. Also, the server has 5 other databases and i don't have any issues in backing up any of the other databases on the shared drive. Any ideas
BackupMedium::ReportIoError: write failure on backup device 'h:\xxxxxx.bak'. Operating system error 1117(The request could not be performed because of an I/O device error.).
Internal I/O request 0x629592F0: Op: Write, pBuffer: 0x19D80000, Size: 983040, Position: 105190912, UMS: Internal: 0x103, InternalHigh: 0x0, Offset: 0x6451600, OffsetHigh: 0x0, m_buf: 0x19D80000, m_len: 983040, m_actualBytes: 0, m_errcode: 1117, BackupFile: h:\xxxxxxxxx.bak
BACKUP failed to complete the command backup database xxxxxxx to disk = 'xxxxxxxx.bak'
June 29, 2004 at 10:22 am
You're having network issues. The backup routine is very intolerant of any network latency. Backup to the local drive and the move it to the shared drive.
June 29, 2004 at 10:53 am
Thanks for the feedback. Do you mean network issues with the network drive ? Also, we have 5 more user databases which are not having any issues to be backed up at the same time. Do you think it might be still related.
June 29, 2004 at 12:21 pm
How big is the database that fails the backup? (Could be timing out)
Are all the databases backing up at the same time or one after the other? (again, could be timing out trying to access the drive when another backup is using it)
Have you tried backing up JUST the database that causes the failure? Does it still fail?
Have you tested this backup procedure at different times of the day? If so, does it still fail the same way? (Could be some network maintenance or other job 'kicks' in when this backup is being done).
-SQLBill
June 29, 2004 at 12:38 pm
How big is the database that fails the backup? (Could be timing out)
The database is only 600 MB big.
Are all the databases backing up at the same time or one after the other? (again, could be timing out trying to access the drive when another backup is using it)
One after another.
Have you tried backing up JUST the database that causes the failure? Does it still fail?
What is weird is that if i try to backup this one database which is giving issues, it fails with the error above. If i backup another database immediately afterwards, it run successfully.
Have you tested this backup procedure at different times of the day? If so, does it still fail the same way? (Could be some network maintenance or other job 'kicks' in when this backup is being done).
Yes, i did test the procedure at different times and same result.
The issue started after we had a failover two days back. I'm just thinking if there is some open thread which might be creating problems and probably a reboot might help. I have opened a case with microsoft and will wait to hear from them.
Thanks everyone for your help.
June 30, 2004 at 2:00 am
June 30, 2004 at 3:10 am
Is 'h:\xxxxxx.bak' always the same file?
Are you appending?
Did you try to delete the file 'h:\xxxxxx.bak' and do the backup afterwards?
Did you try another Filename?
Best regards
karl
Viewing 7 posts - 1 through 6 (of 6 total)
You must be logged in to reply to this topic. Login to reply