Backup Failed

Question

Backup Failed

dba_neo

SSCrazy

Points: 2673
More actions
January 20, 2010 at 11:58 am

#141827

Team,
My Backup job have faile dwith the following error.
BACKUP failed to complete the command BACKUP DATABASE [T1] TO VIRTUAL_DEVICE = 'SQLBACKUP_23C612B2-3FB4-4AE2-AE44-88D91328CC35' WITH BUFFERCOUNT = 6, BLOCKSIZE = 65536, MAXTRANSFERSIZE = 1048576, NAME = N'Database (msdb), 1/19/2010 8:00:25 PM', DESCRIPTION = N'Backup on 1/19/2010 8:00:25 P
BackupMedium::ReportIoError: write failure on backup device 'SQLBACKUP_23C612B2-3FB4-4AE2-AE44-88D91328CC35'. Operating system error 995(The I/O operation has been aborted because of either a thread exit or an application request.).
Internal I/O request 0x65255D38: Op: Write, pBuffer: 0x07090000, Size: 65536, Position: 0, UMS: Internal: 0x3E3, InternalHigh: 0x0, Offset: 0x65255D10, OffsetHigh: 0x0, m_buf: 0x00000000, m_len: 0, m_actualBytes: 0, m_errcode: 995, BackupFile: SQLBACKUP_23C612B2-3FB4-4AE2-AE44-88D91328CC35.

Viewing 12 posts - 1 through 11 (of 11 total)

You must be logged in to reply to this topic. Login to reply

Lynn Pettis SSC Guru Points: 442467 More actions · Answer 1

dba_neo (1/20/2010)
Team,
My Backup job have faile dwith the following error.
BACKUP failed to complete the command BACKUP DATABASE [T1] TO VIRTUAL_DEVICE = 'SQLBACKUP_23C612B2-3FB4-4AE2-AE44-88D91328CC35' WITH BUFFERCOUNT = 6, BLOCKSIZE = 65536, MAXTRANSFERSIZE = 1048576, NAME = N'Database (msdb), 1/19/2010 8:00:25 PM', DESCRIPTION = N'Backup on 1/19/2010 8:00:25 P
BackupMedium::ReportIoError: write failure on backup device 'SQLBACKUP_23C612B2-3FB4-4AE2-AE44-88D91328CC35'. Operating system error 995(The I/O operation has been aborted because of either a thread exit or an application request.).
Internal I/O request 0x65255D38: Op: Write, pBuffer: 0x07090000, Size: 65536, Position: 0, UMS: Internal: 0x3E3, InternalHigh: 0x0, Offset: 0x65255D10, OffsetHigh: 0x0, m_buf: 0x00000000, m_len: 0, m_actualBytes: 0, m_errcode: 995, BackupFile: SQLBACKUP_23C612B2-3FB4-4AE2-AE44-88D91328CC35.

How is this backup being completed?

Where is the backup being written, to a network share?

dba_neo SSCrazy Points: 2673 More actions · Answer 2

yes,the backups for all databases are return to a network share folder.

Gail Shaw SSC Guru Points: 1004504 More actions · Answer 3

That is not a native SQL backup. What tools are you using to do the backups?

Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability

We walk in the dark places no others will enter
We stand on the bridge and no one may pass

Lynn Pettis SSC Guru Points: 442467 More actions · Answer 4

Partly answered my questions. You may have experienced a network issue during the backup. It is recommended that you complete your backups to a local disk resource and then move the backup file from there to a network resource. The backup process is sensitive to network issues that a copy may not. Plus, if the network resource does go down, the actual backup will still complete, just the move to the network resource would fail.

dba_neo SSCrazy Points: 2673 More actions · Answer 5

Team,

we are using Redgate SqlBackup Tools,I think this problem was not related to Network,because the job was failing everyday.

Lynn Pettis SSC Guru Points: 442467 More actions · Answer 6

Sorry, i use the native sql backup with HyperBac. Can't help you with the Redgate product, not familiar with it.

I do have a suggestion, use it to backup to a local disk resource on the server and see if you get the same error.

dba_neo SSCrazy Points: 2673 More actions · Answer 7

iam able to backup the databases to local drive manually.

dba_neo SSCrazy Points: 2673 More actions · Answer 8

this was of version 2000,and i can manually perform backup to network path,but not using job

Lynn Pettis SSC Guru Points: 442467 More actions · Answer 9

Potentially a permissions issue on the share you are backing up to. The service account running the agent service may not have the needed permissions to write to that location.

The_SQL_DBA SSChampion Points: 10494 More actions · Answer 10

I guess if it were a permissions issue then this job would never run. It could either be a network issue or a process accessing your disk at the same time as your backup.

Try changing the backup time and see if that helps complete the backup.

I've had this issue on account of imports running at the same as the backup job..

HTH...

The_SQL_DBA
MCTS

"Quality is never an accident; it is always the result of high intention, sincere effort, intelligent direction and skillful execution; it represents the wise choice of many alternatives."

Lynn Pettis SSC Guru Points: 442467 More actions · Answer 11

Hard to say, but this error, Operating system error 995(The I/O operation has been aborted because of either a thread exit or an application request.), could be the result of insufficient permissions. Easiest thing to check and if necessary correct. If not, then start looking at other possibilities.