Take the 2-minute tour ×
Database Administrators Stack Exchange is a question and answer site for database professionals who wish to improve their database skills and learn from others in the community. It's 100% free, no registration required.

My backup on one of my servers is failing once a week. This is the alert I'm getting:

DESCRIPTION: BackupVirtualDeviceFile::PrepareToFreeze: failure on backup device '{DE47BFA0-E5AD-46DD-868C-F374CB5C2EF7}1'. Operating system error 995(The I/O operation has been aborted because of either a thread exit or an application request.).

I have no idea where to start to figure out why it's fialing, and google hasn't helped me much.

If I look at the application error log on the server, I have a SQLVDI error:

SQLVDI: Loc=SignalAbort. Desc=Client initiates abort. ErrorCode=(0). Process=2028. Thread=2452. Client. Instance=. VD=Global{DE47BFA0-E5AD-46DD-868C-F374CB5C2EF7}1_SQLVDIMemoryName_0.

After that I have a MSSQLSERVER error:

BackupVirtualDeviceFile::PrepareToFreeze: failure on backup device '{DE47BFA0-E5AD-46DD-868C-F374CB5C2EF7}1'. Operating system error 995(The I/O operation has been aborted because of either a thread exit or an application request.).

And a SQLWriter backup:

Sqllib error: OLEDB Error encountered calling ICommandText::Execute. hr = 0x80040e14. SQLSTATE: 42000, Native Error: 3013 Error state: 1, Severity: 16 Source: Microsoft SQL Server Native Client 10.0 Error message: BACKUP DATABASE is terminating abnormally. SQLSTATE: 42000, Native Error: 3271 Error state: 1, Severity: 16 Source: Microsoft SQL Server Native Client 10.0 Error message: A nonrecoverable I/O error occurred on file "{DE47BFA0-E5AD-46DD-868C-F374CB5C2EF7}1:" 995(The I/O operation has been aborted because of either a thread exit or an application request.).

How can I figure out what's causing this failure?

share|improve this question
    
Is it for all databases? Or just one? Does the operation fail at the same time each week? Does it work during other times? What else is running at the same time the backup fails? –  Cougar9000 Jun 11 '13 at 16:31
    
@Cougar9000 yes, all databases. yes, it works at toher times, but seems to always fail on sundays. –  DForck42 Jun 11 '13 at 16:34
1  
How are you executing the backups? –  Cougar9000 Jun 11 '13 at 16:38
2  
Is there any external SAN backup/snapshot tool doing its work at the same time? –  Marian Jun 11 '13 at 16:41
2  
show 4 more comments

Your Answer

 
discard

By posting your answer, you agree to the privacy policy and terms of service.

Browse other questions tagged or ask your own question.