SQL DIFF backup failing at random occasions

msouphy

Hey,

I have SQL Backup 6 configured to take full backups once a day, diff backups every 6 hours, and log backups every 2 hours.

This has been working correctly without any problem for several months now.

Now since two weeks, occasionally, the diff backup fails. Like once every two days or so, it's kinda random.

This is the error message:

6/06/2011 6:00:04: Backing up PanoArchives (differential database) on BTCLUDB instance to: 
6/06/2011 6:00:04:   M:\Backup\PanoArchives\PanoArchives_DIFF_20110606_060004.sqb

6/06/2011 6:00:05: BACKUP DATABASE [PanoArchives]  TO VIRTUAL_DEVICE = 'SQLBACKUP_2D015EAB-296E-40EB-9B34-16C6C0174107', VIRTUAL_DEVICE = 'SQLBACKUP_2D015EAB-296E-40EB-9B34-16C6C017410701' WITH BUFFERCOUNT = 12, BLOCKSIZE = 65536, MAXTRANSFERSIZE = 
 1048576, NAME = N'Database (PanoArchives), 6/06/2011 6:00:04', DESCRIPTION = N'Backup on 6/06/2011 6:00:04  Server: BTCLUDB\BTCLUDB  Database: PanoArchives', FORMAT, DIFFERENTIAL
 
6/06/2011 6:02:07: Thread 0 error: 
Process terminated unexpectedly. Error code: -2139684861 (The api was waiting and the timeout interval had elapsed.)
6/06/2011 6:02:07: 
6/06/2011 6:02:07: Thread 1 error: 
Process terminated unexpectedly. Error code: -2139684861 (The api was waiting and the timeout interval had elapsed.)
6/06/2011 6:02:07: 
6/06/2011 6:02:35: SQL error 3013: SQL error 3013: BACKUP DATABASE is terminating abnormally.
[b]6/06/2011 6:02:35: SQL error 3271: SQL error 3271: A nonrecoverable I/O error occurred on file "SQLBACKUP_2D015EAB-296E-40EB-9B34-16C6C0174107:" 995(failed to retrieve text for this error. Reason: 15105).[/b]

In Windows Server 2008 Event Viewer I have this:

SQLVDI: Loc=SignalAbort. Desc=Client initiates abort. ErrorCode=(0). Process=5132. Thread=5532. Client. Instance=BTCLUDB. VD=Global\SQLBACKUP_2D015EAB-296E-40EB-9B34-16C6C0174107_SQLVDIMemoryName_0.

Some extra info:

- The database server is a windows 2008 cluster with shared disks
- The backup drive (M:) has 123 GB free space, which is plenty in comparison to the size of the database backups (a few gigs), so it isn't a space issue.

Anybody has any ideas what could be causing this ?

thanks

petey

Are you using version 6.5.0 of the SQL Backup server components? If so, could you please update the server components to 6.5.1? You can do this using the 'Check for updates' option in the SQL Backup GUI, to download the updated version of the GUI. After that, you should update the server components on each instance.

msouphy

Thanks for the reply.

Using 6.5.0.73 at the moment.

Will upgrade to 6.5.1

I see in the release notes for 6.5.1:

VDI timeout removed. This was causing some restore operations for larger databases to time out before completion.

My problems occurs when taking backups, not restores.

But maybe this will solve this too ?

petey

But maybe this will solve this too ?

Yes it will.